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

Kurssisisältö

Test UI Features

1. Buttons

Hint/Solution Buttons Hint/Solution/Video Tutorial Buttons Hint and Solution Single Block Buttons Code Description Button Download File in the TXT format Download Course Summary

2. ContentDev Tools

Markdown Parsing Colors RegExp Creation Item Feedbacks

3. Image Tools

Image Image Swiper

4. Links

Link in a Text Link to Github and CodeSandbox

5. Other

Windows / Apple / Linux Instructions NN Cat/Dog CNN Hyperparameters Encryption Block Text with Color Legend Danyas playground Oleh S tests

6. Text Boxes

7. Tables

Scrollable Framed Table Table with the Tooltip Matrices

8. Developers

9. Deprecated

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

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 2. Luku 4