Item Feedbacks
To list feedbacks of a particular item:
- Go to the feedbacks file and select the index of the needed feedback (Excel's row index - 2).
- Input this index as
POS
value in the code sample below. E.g.POS = 21
for Excel's index 23. - Run the code sample.
1234567891011121314151617181920212223242526272829# Set up position POS = 0 # Imports import pandas as pd import json # Load and parse excel if not 'xl' in locals(): print('Loading...\n') sheet_id = '18sDAkhpzqfVdyf9gX26oZ6zfLLkkMBnO-NooTU9AIIA' xl = pd.ExcelFile(f"https://docs.google.com/spreadsheets/export?id={sheet_id}&format=xlsx") sheet_names = xl.sheet_names last_sheet = sheet_names[0] # Read the last sheet to DataFrame df = xl.parse(last_sheet) # Load data sample s = df['Comment'].iloc[POS] # Filter null values s = s.replace(', null,', ', "",').replace('[null', '[""').replace('null]', '""]') # Display s = pd.Series(json.loads(s)).str.wrap(70) for i, r in enumerate(s): print(f'{i}: {r}') print('-' * 70)
Все було зрозуміло?
Дякуємо за ваш відгук!
Секція 2. Розділ 4
Запитати АІ
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
Awesome!
Completion rate improved to 1.22
Item Feedbacks
Свайпніть щоб показати меню
To list feedbacks of a particular item:
- Go to the feedbacks file and select the index of the needed feedback (Excel's row index - 2).
- Input this index as
POS
value in the code sample below. E.g.POS = 21
for Excel's index 23. - Run the code sample.
1234567891011121314151617181920212223242526272829# Set up position POS = 0 # Imports import pandas as pd import json # Load and parse excel if not 'xl' in locals(): print('Loading...\n') sheet_id = '18sDAkhpzqfVdyf9gX26oZ6zfLLkkMBnO-NooTU9AIIA' xl = pd.ExcelFile(f"https://docs.google.com/spreadsheets/export?id={sheet_id}&format=xlsx") sheet_names = xl.sheet_names last_sheet = sheet_names[0] # Read the last sheet to DataFrame df = xl.parse(last_sheet) # Load data sample s = df['Comment'].iloc[POS] # Filter null values s = s.replace(', null,', ', "",').replace('[null', '[""').replace('null]', '""]') # Display s = pd.Series(json.loads(s)).str.wrap(70) for i, r in enumerate(s): print(f'{i}: {r}') print('-' * 70)
Все було зрозуміло?
Дякуємо за ваш відгук!
Секція 2. Розділ 4