File size: 1,512 Bytes
c9665af |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 |
import requests
url = "https://bloomberg-market-and-financial-news.p.rapidapi.com/news/list-by-region"
querystring = {"id":"europe-home-v3"}
headers = {
"X-RapidAPI-Key": "ee0947a6afmshd9a0846869b0f80p12916fjsn610316852108",
"X-RapidAPI-Host": "bloomberg-market-and-financial-news.p.rapidapi.com"
}
response = requests.request("GET", url, headers=headers, params=querystring)
print(response.text)
print('***************************************************************************')
print('***************************************************************************')
print('***************************************************************************')
print('***************************************************************************')
print('***************************************************************************')
jsondata = response.json()
print(jsondata)
print('***************************************************************************')
print('***************************************************************************')
print('***************************************************************************')
print('***************************************************************************')
print('***************************************************************************')
print(jsondata.keys())
from pandas import json_normalize
import requests
import json
import pandas as pd
textdata = json.loads(response.text)
res = json_normalize(textdata)
df = pd.DataFrame(res)
print(df.shape) |