JSON dosyasını ayıklama

Python
1

import requests
import json
url = “https://api.xxxxxx.com”

payload={}
headers = {}

response = requests.request(“GET”, url, headers=headers, data=payload)

print(response.text)
organ=json.loads(response.text)
print(type(organ))
new=list(organ.keys())
print(new)

YUKARIDAKİ KOMUT İLE ALINAN GÖRÜNTÜ ŞUDUR

{“status”:true,“data”:[{“date”:1644667200,“hashrate”:85},{“date”:1644666600,“hashrate”:170},{“date”:1644666000,“hashrate”:170},{“date”:1644665400,“hashrate”:136},{“date”:1644570000,“hashrate”:221},{“date”:1644569400,“hashrate”:85},{“date”:1644568800,“hashrate”:85},{“date”:1644568200,“hashrate”:85},{“date”:1644567600,“hashrate”:102},{“date”:1644567000,“hashrate”:187},{“date”:1644566400,“hashrate”:51},{“date”:1644565800,“hashrate”:102},{“date”:1644565200,“hashrate”:119},{“date”:1644564600,“hashrate”:136},{“date”:1644564000,“hashrate”:119},{“date”:1644563400,“hashrate”:136},{“date”:1644562800,“hashrate”:119},{“date”:1644562200,“hashrate”:34},{“date”:1644561600,“hashrate”:136},{“date”:1644561000,“hashrate”:68},{“date”:1644560400,“hashrate”:187},{“date”:1644559800,“hashrate”:119},{“date”:1644559200,“hashrate”:102},{“date”:1644558600,“hashrate”:68},{“date”:1644558000,“hashrate”:51},{“date”:1644557400,“hashrate”:68},{“date”:1644556800,“hashrate”:102},{“date”:1644556200,“hashrate”:153},{“date”:1644555600,“hashrate”:204},{“date”:1644555000,“hashrate”:170},{“date”:1644554400,“hashrate”:136},{“date”:1644553800,“hashrate”:153},{“date”:1644553200,“hashrate”:187},{“date”:1644552600,“hashrate”:85},{“date”:1644552000,“hashrate”:68},{“date”:1644551400,“hashrate”:119},{“date”:1644550800,“hashrate”:102},{“date”:1644550200,“hashrate”:136},{“date”:1644549600,“hashrate”:51},{“date”:1644549000,“hashrate”:68},{“date”:1644548400,“hashrate”:34},{“date”:1644547800,“hashrate”:85},{“date”:1644547200,“hashrate”:34},{“date”:1644546600,“hashrate”:85},{“date”:1644546000,“hashrate”:153},{“date”:1644545400,“hashrate”:68},{“date”:1644544800,“hashrate”:102},{“date”:1644544200,“hashrate”:51},{“date”:1644543600,“hashrate”:170}]}

İSTENİLEN İSE “data”:[{“date” :… , “hashrate” : … }] verilerinin Tablo , liste ya da csv dosyası haline getirilip yeni bir dosya olarak kaydedilmesidir.

Şu ana kadar liste konusu ile yaptığım denemelerde sadece şuna ulaşabildim :

import requests
import json
import csv
import pandas as pd

url = “https://api.xxxxxxx.xom”

payload={}
headers = {}

response = requests.request(“GET”, url, headers=headers, data=payload)
organ=json.loads(response.text)

print(type(organ))
new=list(organ.keys())
print(type(new))
print(new)

2