Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lära Item Feedbacks | ContentDev Tools
Test UI Features

bookItem 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)
copy

Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 2. Kapitel 4

Fråga AI

expand

Fråga AI

ChatGPT

Fråga vad du vill eller prova någon av de föreslagna frågorna för att starta vårt samtal

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

bookItem Feedbacks

Svep för att visa menyn

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)
copy

Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 2. Kapitel 4
some-alt