[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]