JSON
là 1 dạng dữ liệu khá phổ biến trong thực tế.
[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"},
{"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"},
{"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"},
{"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"},
{"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
0 Tệp hỗ trợ đọc JSON
theo phương thức saupd.read_json[path_or_buf=None, orient=None,...]
in which
2. is path to file json or Object for before[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"}, {"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"}, {"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"}, {"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"}, {"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
3. json kiểu cấu trúc[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"}, {"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"}, {"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"}, {"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"}, {"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
4. Dữ liệu có dạng dictionary theo cấu trúc[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"}, {"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"}, {"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"}, {"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"}, {"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
5[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"}, {"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"}, {"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"}, {"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"}, {"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
6. Dữ liệu có dạng danh sách các từ điển theo cấu trúc[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"}, {"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"}, {"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"}, {"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"}, {"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
7[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"}, {"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"}, {"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"}, {"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"}, {"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
8. Từ điển dữ liệu dạng theo cấu trúc[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"}, {"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"}, {"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"}, {"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"}, {"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
9[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"}, {"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"}, {"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"}, {"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"}, {"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
0. Từ điển dữ liệu dạng theo cấu trúcdf = pd.read_json['sample_pokemon.json', orient='records'] df.head[]
1df = pd.read_json['sample_pokemon.json', orient='records'] df.head[]
2. danh sách các giá trịdf = pd.read_json['sample_pokemon.json', orient='records'] df.head[]
Ngoài ra còn có các tham số khác nữa như
3,df = pd.read_json['sample_pokemon.json', orient='records'] df.head[]
4, các bạn có thể tham khảo tại pd. read_json[]df = pd.read_json['sample_pokemon.json', orient='records'] df.head[]
Dưới đây là tệp
df = pd.read_json['sample_pokemon.json', orient='records']
df.head[]
5 với các cấu trúc như sauCấu trúc
[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"},
{"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"},
{"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"},
{"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"},
{"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
6[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"},
{"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"},
{"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"},
{"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"},
{"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
ta could call
df = pd.read_json['sample_pokemon.json', orient='records']
df.head[]
name type height weight
0 Bulbasaur [Grass, Poison] 0.71 m 6.9 kg
1 Ivysaur [Grass, Poison] 0.99 m 13.0 kg
2 Venusaur [Grass, Poison] 2.01 m 100.0 kg
3 Charmander [Fire] 0.61 m 8.5 kg
4 Charmeleon [Fire] 1.09 m 19.0 kg
Tương tự với cấu trúc
[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"},
{"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"},
{"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"},
{"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"},
{"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
4{"index": [0,1,2,3,4],
"columns": ["name","type","height","weight"],
"data": [["Bulbasaur",["Grass","Poison"],"0.71 m","6.9 kg"],
["Ivysaur",["Grass","Poison"],"0.99 m","13.0 kg"],
["Venusaur",["Grass","Poison"],"2.01 m","100.0 kg"],
["Charmander",["Fire"],"0.61 m","8.5 kg"],
["Charmeleon",["Fire"],"1.09 m","19.0 kg"]]}
ta could call
df = pd.read_json['sample_pokemon.json', orient='split']
df.head[]
Các cấu trúc còn lại
[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"},
{"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"},
{"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"},
{"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"},
{"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
8{"0":{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"},
"1":{"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"},
"2":{"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"},
"3":{"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"},
"4":{"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}}
df = pd.read_json['sample_pokemon.json', orient='records']
df.head[]
0{"name":{"0":"Bulbasaur",
"1":"Ivysaur",
"2":"Venusaur",
"3":"Charmander"
"4":"Charmeleon"},
"type":{"0":["Grass","Poison"],
"1":["Grass","Poison"],
"2":["Grass","Poison"],
"3":["Fire"],
"4":["Fire"]},
"height":{"0":"0.71 m",
"1":"0.99 m",
"2":"2.01 m",
"3":"0.61 m",
"4":"1.09 m"},
"weight":{"0":"6.9 kg",
"1":"13.0 kg",
"2":"100.0 kg",
"3":"8.5 kg",
"4":"19.0 kg"}}
df = pd.read_json['sample_pokemon.json', orient='records']
df.head[]
2[["Bulbasaur",["Grass","Poison"],"0.71 m","6.9 kg"],
["Ivysaur",["Grass","Poison"],"0.99 m","13.0 kg"],
["Venusaur",["Grass","Poison"],"2.01 m","100.0 kg"],
["Charmander",["Fire"],"0.61 m","8.5 kg"],
["Charmeleon",["Fire"],"1.09 m","19.0 kg"]]
Lưu ý
1 mặc địnhname type height weight 0 Bulbasaur [Grass, Poison] 0.71 m 6.9 kg 1 Ivysaur [Grass, Poison] 0.99 m 13.0 kg 2 Venusaur [Grass, Poison] 2.01 m 100.0 kg 3 Charmander [Fire] 0.61 m 8.5 kg 4 Charmeleon [Fire] 1.09 m 19.0 kg
2. Các cấu trúcname type height weight 0 Bulbasaur [Grass, Poison] 0.71 m 6.9 kg 1 Ivysaur [Grass, Poison] 0.99 m 13.0 kg 2 Venusaur [Grass, Poison] 2.01 m 100.0 kg 3 Charmander [Fire] 0.61 m 8.5 kg 4 Charmeleon [Fire] 1.09 m 19.0 kg
6 và[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"}, {"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"}, {"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"}, {"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"}, {"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]
8 là các cấu trúc JSON thường gặp[{"name":"Bulbasaur","type":["Grass","Poison"],"height":"0.71 m","weight":"6.9 kg"}, {"name":"Ivysaur","type":["Grass","Poison"],"height":"0.99 m","weight":"13.0 kg"}, {"name":"Venusaur","type":["Grass","Poison"],"height":"2.01 m","weight":"100.0 kg"}, {"name":"Charmander","type":["Fire"],"height":"0.61 m","weight":"8.5 kg"}, {"name":"Charmeleon","type":["Fire"],"height":"1.09 m","weight":"19.0 kg"}]