найти и исправить ошибку import json import requests from pprint import pprint token =…
- 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
- 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))Теперь код должен работать без ошибок.
- User
4,1667 округлить до сотых
- Assistant
4,1667 округлить до сотых равно 4,17.