Skip to main content

Blog

Learn About Our Meetup

5000+ Members

MEETUPS

LEARN, CONNECT, SHARE

Join our meetup, learn, connect, share, and get to know your Toronto AI community. 

JOB POSTINGS

INDEED POSTINGS

Browse through the latest deep learning, ai, machine learning postings from Indeed for the GTA.

CONTACT

CONNECT WITH US

Are you looking to sponsor space, be a speaker, or volunteer, feel free to give us a shout.

[P] Create daily summary from .json file to pandas dataframe in python

So I’m creating a weather forecast for a project and I need to analyze some historical data from a .json file. I want to create a list of daily summaries with the values from each dates. The .json layout looks like this:

{“city_id”:3160606,”main”:{“temp”:285.88,”temp_min”:284.26,”temp_max”:288.15,”pressure”:1015,”humidity”:79},”wind”:{“speed”:1,”deg”:166},”rain”:{“3h”:0.025},”clouds”:{“all”:80},”weather”:[{“id”:803,”main”:”Clouds”,”description”:”broken clouds”,”icon”:”04n”}],”dt”:1474588800,”dt_iso”:”2016-09-23 00:00:00 +0000 UTC”},{“city_id”:3160606,”main”:{“temp”:285.34,”temp_min”:284.26,”temp_max”:287.04,”pressure”:1015,”humidity”:82},”wind”:{“speed”:1,”deg”:166},”rain”:{“3h”:0.025},”clouds”:{“all”:80},”weather”:[{“id”:803,”main”:”Clouds”,”description”:”broken clouds”,”icon”:”04n”}],”dt”:1474592400,”dt_iso”:”2016-09-23 01:00:00 +0000 UTC”},

Any help on how I can get data from every specific day sorted in a good way?

submitted by /u/WiseAfro27
[link] [comments]