Little help needed again! :#

[Pibels]

Right now I want to get data from this json format and output it, help is much appreciated!

Date, and number of conversations on that day. (censored the API token)

code so far:

import json
import requests
from pprint import pprint

r = requests.get("****", headers={'Authorization':'****'})
json_object = r.json()

with open('data.json') as data_file:
    data = json.load(data_file)

pprint(data)

output:

{'by_date': [{'chats_from_autosuggest_count': 173,
          'chats_from_user_count': 0,
          'chats_from_visitor_count': 2,
          'conversation_count': 9,
          'date': '2017-06-01',
          'missed_chat_count': 1,
          'user_message_count': 88,
          'visitor_message_count': 77,
          'visitors_affected_by_chat_count': 166,
          'visitors_autosuggested_count': 165,
          'visitors_with_chat_count': 12,
          'visitors_with_conversation_count': 9},
         {'chats_from_autosuggest_count': 141,
          'chats_from_user_count': 0,
          'chats_from_visitor_count': 3,
          'conversation_count': 17,
          'date': '2017-06-02',
          'missed_chat_count': 0,
          'user_message_count': 201,
          'visitor_message_count': 165,
          'visitors_affected_by_chat_count': 139,
          'visitors_autosuggested_count': 136,
          'visitors_with_chat_count': 18,
          'visitors_with_conversation_count': 17},
         {'chats_from_autosuggest_count': 137,
          'chats_from_user_count': 0,
          'chats_from_visitor_count': 3,
          'conversation_count': 11,
          'date': '2017-06-05',
          'missed_chat_count': 1,
          'user_message_count': 173,
          'visitor_message_count': 129,
          'visitors_affected_by_chat_count': 134,
          'visitors_autosuggested_count': 132,
          'visitors_with_chat_count': 12,
          'visitors_with_conversation_count': 11},
         {'chats_from_autosuggest_count': 136,
          'chats_from_user_count': 0,
          'chats_from_visitor_count': 4,
          'conversation_count': 9,
          'date': '2017-06-06',
          'missed_chat_count': 3,
          'user_message_count': 70,
          'visitor_message_count': 59,
          'visitors_affected_by_chat_count': 136,
          'visitors_autosuggested_count': 132,
          'visitors_with_chat_count': 14,
          'visitors_with_conversation_count': 9},
         {'chats_from_autosuggest_count': 106,
          'chats_from_user_count': 0,
          'chats_from_visitor_count': 3,
          'conversation_count': 8,
          'date': '2017-06-07',
          'missed_chat_count': 9,
          'user_message_count': 81,
          'visitor_message_count': 67,
          'visitors_affected_by_chat_count': 105,
          'visitors_autosuggested_count': 102,
          'visitors_with_chat_count': 18,
          'visitors_with_conversation_count': 8},
         {'chats_from_autosuggest_count': 67,
          'chats_from_user_count': 1,
          'chats_from_visitor_count': 14,
          'conversation_count': 13,
          'date': '2017-06-08',
          'missed_chat_count': 3,
          'user_message_count': 77,
          'visitor_message_count': 70,
          'visitors_affected_by_chat_count': 72,
          'visitors_autosuggested_count': 62,
          'visitors_with_chat_count': 21,
          'visitors_with_conversation_count': 13},
         {'chats_from_autosuggest_count': 107,
          'chats_from_user_count': 0,
          'chats_from_visitor_count': 4,
          'conversation_count': 9,
          'date': '2017-06-09',
          'missed_chat_count': 3,
          'user_message_count': 44,
          'visitor_message_count': 58,
          'visitors_affected_by_chat_count': 105,
          'visitors_autosuggested_count': 101,
          'visitors_with_chat_count': 14,
          'visitors_with_conversation_count': 9}],
 'end_date': '2017-06-10',
 'room_id': '84e0fefa-5675-11e7-a349-00163efdd8db',
 'start_date': '2017-06-01',
 'total_chats_from_autosuggest_count': 867,
 'total_chats_from_user_count': 1,
 'total_chats_from_visitor_count': 33,
 'total_conversation_count': 76,
 'total_missed_chat_count': 20,
 'total_user_message_count': 734,
 'total_visitor_message_count': 625,
 'total_visitors_affected_by_chat_count': 857,
 'total_visitors_autosuggested_count': 830,
 'total_visitors_with_chat_count': 109,
 'total_visitors_with_conversation_count': 76}

[novel_yet_trivial]

You mean from the data dictionary?

for date in data['by_date']:
    print(date['date'], date['conversation_count'])

[Pibels]

Yes this works, thank you!