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)
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 2. Capítulo 4
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Suggested prompts:
How do I find the correct POS value for a specific feedback?
Can you explain what the code does step by step?
What should I do if I get an error when running the code?
Awesome!
Completion rate improved to 1.22
Item Feedbacks
Desliza para mostrar el menú
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)
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 2. Capítulo 4