# Import Pandas
import pandas as pd
# Read in ICA schedule CSV - assumes file is in current working directory
data = pd.read_csv('ica_schedule.csv', index_col = 'Session or Event Division/Interest Group')
# Drop irrelevant columns
#data = data.drop(['Session or Event Division/Interest Group','Session or Event Type','Session or Event Start Time','Session or Event End Time','Session or Event Location','Session or Event Details','Session or Event End Time','Session or Event Participants/Hosts','Submission or Placeholder Start Time','Submission or Placeholder End Time','Submission Status','Session Submission Sort Order','The Program Report was last updated May 12, 2020 at 01:17 AM EDT. To view the most recent meeting schedule online, visit https://ica2020.abstractcentral.com/planner.jsp'],axis=1)
data = data.drop(['Session or Event Type','Session or Event Date','Session or Event Start Time','Session or Event End Time','Session or Event Location','Session or Event Details','Session or Event End Time','Session or Event Participants/Hosts','Submission or Placeholder Start Time','Submission or Placeholder End Time','Submission Status','Session Submission Sort Order','The Program Report was last updated May 12, 2020 at 01:17 AM EDT. To view the most recent meeting schedule online, visit https://ica2020.abstractcentral.com/planner.jsp'],axis=1)
# Rename columns for readability
data = data.rename(columns={'Session or Event Title':'Title','Submission or Placeholder Title':'Talk Title','Submission Authors':'Authors'})
# Show entire cell content
pd.set_option('display.max_colwidth', -1)