Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Oppiskele 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

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 2. Luku 4

Kysy tekoälyä

expand

Kysy tekoälyä

ChatGPT

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

Awesome!

Completion rate improved to 1.22

bookItem Feedbacks

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

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 2. Luku 4
some-alt