I am trying to get data from an api ( https://min-api.cryptocompare.com/data/histoday?fsym=BTC&tsym=ETH&limit=30&aggregate=1&e=CCCAGG ) to pandas. API gives data in Json. df = pd.read_json('new.json' , orient = 'columns') Error: Mixing dicts with non-Series may lead to ambiguous ordering. Data i need:- Image Link : https://i.sstatic.net/zsCA5.jpg I am really new to this, any help would be fantastic. Continue reading...