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

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 2. Luku 4

Kysy tekoälyä

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

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?

Pyyhkäise näyttääksesi valikon

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)

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 2. Luku 4

Item Feedbacks

Awesome!

Item Feedbacks