|
import requests |
|
|
|
url = "https://bloomberg-market-and-financial-news.p.rapidapi.com/market/auto-complete" |
|
|
|
|
|
querystring = {"query":"company"} |
|
|
|
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()) |
|
|
|
print(type(jsondata['quote'])) |
|
print(type(jsondata['news'])) |
|
import pandas as pd |
|
df = pd.DataFrame(jsondata['quote']) |
|
df2 = pd.DataFrame(jsondata['news']) |
|
print('***************************************************************************') |
|
print(df.info()) |
|
print(df2.info()) |
|
print('***************************************************************************') |
|
print(df.head(3)) |
|
print(df2.head(3)) |
|
print('***************************************************************************') |
|
print(df.shape) |
|
print(df2.shape) |
|
print('***************************************************************************') |
|
print(df.columns) |
|
print(df2.columns) |
|
print('***************************************************************************') |
|
df3 = pd.concat([df, df2], axis = 1) |
|
print(df3.columns) |
|
print(df3.shape) |
|
print('***************************************************************************') |
|
|