Pandas JSON o‘qish
JSON’ni o‘qish
Katta ma’lumotlar to‘plamlari ko‘pincha JSON ko‘rinishida saqlanadi yoki JSON sifatida olinadi.
JSON oddiy matn, ammo u obyekt formatiga ega va dasturlash olamida, jumladan Pandas’da ham yaxshi tanilgan.
Misollarimizda 'data.json' nomli JSON fayldan foydalanamiz.
Misol
JSON faylni DataFrame’ga yuklang:
import pandas as pd
df = pd.read_json('data.json')
print(df.to_string())
O‘zingiz sinab ko‘ring »
Maslahat: butun DataFrame’ni chiqarish uchun to_string() metodidan foydalaning.
Dictionary JSON sifatida
JSON = Python dictionary
JSON obyektlari Python dictionary’lari bilan bir xil formatga ega.
Agar JSON kodingiz faylda emas, balki Python dictionary’sida bo‘lsa, uni to‘g‘ridan-to‘g‘ri DataFrame’ga yuklashingiz mumkin:
Misol
Python dictionary’sini DataFrame’ga yuklang:
import pandas as pd
data = {
"Duration":{
"0":60,
"1":60,
"2":60,
"3":45,
"4":45,
"5":60
},
"Pulse":{
"0":110,
"1":117,
"2":103,
"3":109,
"4":117,
"5":102
},
"Maxpulse":{
"0":130,
"1":145,
"2":135,
"3":175,
"4":148,
"5":127
},
"Calories":{
"0":409,
"1":479,
"2":340,
"3":282,
"4":406,
"5":300
}
}
df = pd.DataFrame(data)
print(df)
O‘zingiz sinab ko‘ring »
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!