<jupyter_start><jupyter_text>this is a first view of the CSV export From the GSheet document created by John: https://docs.google.com/spreadsheets/d/1KjYydaCgeMm-Xwh3PQEeY82MQLDlJGZ-/<jupyter_code>import osbot_jupyter
%%HTML

<iframe src="https://docs.google.com/spreadsheets/d/1KjYydaCgeMm-Xwh3PQEeY82MQLDlJGZ-/" width="100%" , height="500">
import pandas as pd
csv_file = './Session Data and Tags--20190601.xlsx - Sheet1.csv'
df_sessions = pd.read_csv(csv_file)
df_sessions
df_sessions.columns
import qgrid
columns = ['Title', 'Track', 'Type', 'Organiser(s)', 'Participants',
           'Day', 'Time', 'Synopsis?', 'Locked?',
           # 'OWASP Type', 'CSF Category', 'SAMM 2.0 Practice & Stream', 'Tags',
           # 'Notes','Remote Participants'
          ]
qgrid.show_grid(df_sessions[columns])
df_sessions['CSF Category'].group_by('CSF Category')<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.1493212669683258, 'fraction_numerical': 0.02828054298642534, 'mean_word_length': 4.939597315436242, 'pattern_counts': {'":': 0, '<': 6, '<?xml version=': 0, '>': 6, 'https://': 2, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '618648', 'license': 'Apache-2.0', 'n_tokens_mistral': 364, 'n_tokens_neox': 330, 'n_words': 64, 'path': 'notebooks/users/john-dileo/session-data-mappings/first-view-of-csv-data.ipynb', 'repo_name': 'dariovillalon/jp-2020', 'size': '884'}