Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Вивчайте 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

Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 2. Розділ 4

Запитати АІ

expand

Запитати АІ

ChatGPT

Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат

Awesome!

Completion rate improved to 1.22

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

Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 2. Розділ 4
some-alt