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)
Everything was clear?
Thanks for your feedback!
SectionΒ 2. ChapterΒ 4
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 1.22
Item Feedbacks
Swipe to show menu
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)
Everything was clear?
Thanks for your feedback!
SectionΒ 2. ChapterΒ 4