Lära Item Feedbacks | ContentDev Tools

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)

Var allt tydligt?

Tack för dina kommentarer!

Avsnitt 2. Kapitel 4

Fråga AI

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

Awesome!

Completion rate improved to 1.19

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)

Var allt tydligt?

Tack för dina kommentarer!

Avsnitt 2. Kapitel 4