Download our e-book of Introduction To Python
Neha Kumawat
2 years ago
{
"employees": [
{
"id": 1,
"name": "Amit",
"dept": "IT"
},
{
"id": 2,
"name": "Asif",
"dept": "HR"
},
{
"id": 3,
"name": "Rohit",
"dept": "IT"
}
]
}
import pandas as pd
pandas.read_json(path_or_buf=None, orient=None, typ='frame', dtype=None, convert_axes=None,
convert_dates=True, keep_default_dates=True, numpy=False, precise_float=False, date_unit=None,
encoding=None, encoding_errors='strict', lines=False, chunksize=None, compression='infer',
nrows=None, storage_options=None)
import pandas as pd
data = pd.read_json('input.json')
print (data)
employees
0 {'id': 1, 'name': 'Amit', 'dept': 'IT'}
1 {'id': 2, 'name': 'Asif', 'dept': 'HR'}
2 {'id': 3, 'name': 'Rohit', 'dept': 'IT'}
DataFrame.to_json(path_or_buf=None, orient=None, date_format=None, double_precision=10,
force_ascii=True, date_unit='ms', default_handler=None, lines=False, compression='infer',
index=True, indent=None, storage_options=None)
import pandas as pd
import json
df = pd.DataFrame(
[["x", "y"], ["w", "z"]],
index=["row_1", "row_2"],
columns=["col_1", "col_2"],
)
result = df.to_json(orient="split")
parsed = json.loads(result)
print(json.dumps(parsed, indent=3) )
{
"columns": [
"col_1",
"col_2"
],
"index": [
"row_1",
"row_2"
],
"data": [
[
"x",
"y"
],
[
"w",
"z"
]
]
}