Skip to content
The Chat Archive
gpt-3.5-turbo-0613· OpenAI WildChat-4.8M (AI2)

найти и исправить ошибку import json import requests from pprint import pprint token =…

  1. User

    найти и исправить ошибку import json import requests from pprint import pprint token = 'y0_AQAAAABjzbrxAAhSRgAAAADLeXue6m1bxVOZSMiw5nR6v6aekQcMVz8'

    headers = {'Authorization': 'OAuth ' + token} params2 = {'metrics': 'ym:s:visits,ym:s:goal137595631reaches', 'dimensions': 'ym:s:lastTrafficSource',
    'date1': '2020-10-07',
    'date2': '2020-10-09',
    'ids': 30177909, 'accuracy':'full', 'limit':100000} response = requests.get('https://api-metrika.yandex.net/stat/v1/data', params=params2, headers=headers) print (response.status_code)

    metrika_data2 = response.json() metrika_df2 = pd.DataFrame(metrika_data2['data']) metrika_list_of_dicts2 = getMetrikaDataInListOfDicts(metrika_data2) metrika_df2 = pd.DataFrame(metrika_list_of_dicts2) metrika_df2.columns=['Source','Visits','Conversions'] metrika_df2['Last click CR%'] = metrika_df2['Conversions']/metrika_df2['Visits'] display(metrika_df2.head(10))

    NameError Traceback (most recent call last) Cell In[3], line 18 15 print (response.status_code) 17 metrika_data2 = response.json() ---> 18 metrika_df2 = pd.DataFrame(metrika_data2['data']) 19 metrika_list_of_dicts2 = getMetrikaDataInListOfDicts(metrika_data2) 20 metrika_df2 = pd.DataFrame(metrika_list_of_dicts2)

    NameError: name 'pd' is not defined

  2. Assistant

    Для исправления ошибки нужно добавить строку импорта библиотеки pandas (pd). Вот исправленный код:

    import json 
    import requests
    from pprint import pprint
    import pandas as pd
    
    token = 'y0_AQAAAABjzbrxAAhSRgAAAADLeXue6m1bxVOZSMiw5nR6v6aekQcMVz8'
    
    headers = {'Authorization': 'OAuth ' + token}
    params2 = {'metrics': 'ym:s:visits,ym:s:goal137595631reaches',
              'dimensions': 'ym:s:lastTrafficSource',  
              'date1': '2020-10-07',  
              'date2': '2020-10-09',    
              'ids': 30177909,
              'accuracy':'full',
              'limit':100000}
    response = requests.get('https://api-metrika.yandex.net/stat/v1/data', params=params2, headers=headers)
    print(response.status_code)
    
    metrika_data2 = response.json()
    metrika_df2 = pd.DataFrame(metrika_data2['data'])
    metrika_list_of_dicts2 = getMetrikaDataInListOfDicts(metrika_data2)
    metrika_df2 = pd.DataFrame(metrika_list_of_dicts2)
    metrika_df2.columns=['Source','Visits','Conversions']
    metrika_df2['Last click CR%'] = metrika_df2['Conversions']/metrika_df2['Visits']
    display(metrika_df2.head(10))
    

    Теперь код должен работать без ошибок.

  3. User

    4,1667 округлить до сотых

  4. Assistant

    4,1667 округлить до сотых равно 4,17.