Python Forum
Getting values from a dictionary
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Getting values from a dictionary
#6
It can be easier if take data first into Pandas,then get out all kind of formats.
A example and for plain text can use df.to_string.
import requests
import pandas as pd

# Api
url = 'https://min-api.cryptocompare.com/data/histoday?fsym=BTC&tsym=ETH&limit=5&aggregate=1&e=CCCAGG'
data = requests.get(url).json()['Data']

# To Pandas
df = pd.DataFrame.from_dict(data)

# To txt
with open('out.txt', 'w') as f:
    f.write(df.to_string(index=False))
Output:
time high low open volumefrom volumeto close conversionType conversionSymbol 1616716800 33.01 32.01 32.36 14147.54 459354.17 32.39 invert 1616803200 32.93 32.19 32.39 14604.07 475135.19 32.62 invert 1616889600 33.10 32.58 32.62 12160.02 399198.72 33.08 invert 1616976000 33.11 31.50 33.08 16051.11 517814.86 31.73 invert 1617062400 32.23 31.54 31.73 14830.86 474005.03 31.92 invert 1617148800 32.34 30.28 31.92 21814.13 688238.39 30.71 invert
Reply


Messages In This Thread
Getting values from a dictionary - by brunolelli - Mar-31-2021, 07:24 PM
RE: Getting values from a dictionary - by snippsat - Mar-31-2021, 11:57 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Replace values in Yaml file with value in dictionary PelleH 0 174 Jun-12-2024, 02:40 PM
Last Post: PelleH
Question Using Lists as Dictionary Values bfallert 8 738 Apr-21-2024, 06:55 AM
Last Post: Pedroski55
  need to compare 2 values in a nested dictionary jss 2 1,031 Nov-30-2023, 03:17 PM
Last Post: Pedroski55
  Printing specific values out from a dictionary mcoliver88 6 1,622 Apr-12-2023, 08:10 PM
Last Post: deanhystad
Question How to print each possible permutation in a dictionary that has arrays as values? noahverner1995 2 1,894 Dec-27-2021, 03:43 AM
Last Post: noahverner1995
  Python dictionary with values as list to CSV Sritej26 4 3,230 Mar-27-2021, 05:53 PM
Last Post: Sritej26
  Conceptualizing modulus. How to compare & communicate with values in a Dictionary Kaanyrvhok 7 4,221 Mar-15-2021, 05:43 PM
Last Post: Kaanyrvhok
  Adding keys and values to a dictionary giladal 3 2,647 Nov-19-2020, 04:58 PM
Last Post: deanhystad
  In this dictionary all the values end up the same. How? Pedroski55 2 2,032 Oct-29-2020, 12:32 AM
Last Post: Pedroski55
  Counting the values ​​in the dictionary Inkanus 7 3,945 Oct-26-2020, 01:28 PM
Last Post: Inkanus

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020