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 152 Jun-12-2024, 02:40 PM
Last Post: PelleH
Question Using Lists as Dictionary Values bfallert 8 704 Apr-21-2024, 06:55 AM
Last Post: Pedroski55
  need to compare 2 values in a nested dictionary jss 2 1,014 Nov-30-2023, 03:17 PM
Last Post: Pedroski55
  Printing specific values out from a dictionary mcoliver88 6 1,589 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,883 Dec-27-2021, 03:43 AM
Last Post: noahverner1995
  Python dictionary with values as list to CSV Sritej26 4 3,224 Mar-27-2021, 05:53 PM
Last Post: Sritej26
  Conceptualizing modulus. How to compare & communicate with values in a Dictionary Kaanyrvhok 7 4,187 Mar-15-2021, 05:43 PM
Last Post: Kaanyrvhok
  Adding keys and values to a dictionary giladal 3 2,637 Nov-19-2020, 04:58 PM
Last Post: deanhystad
  In this dictionary all the values end up the same. How? Pedroski55 2 2,025 Oct-29-2020, 12:32 AM
Last Post: Pedroski55
  Counting the values ​​in the dictionary Inkanus 7 3,914 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