Item Feedbacks

              
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)