data

#!/bin/bash
# Load the file referenced in the first argument into a Jupyter QtConsole as df

# change to appropriate conda environment
source activate py37

tempscript=`mktemp`

tee "$tempscript" <<EOF
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

# triple quotes for safety
filename = '''$1'''

if filename.endswith('.csv'):
  df = pd.read_csv(filename)
elif filename.endswith('.tsv'):
  df = pd.read_csv(filename, sep='\t')
elif filename.endswith('.xls') or filename.endswith('.xlsx'):
  df = pd.read_excel(filename)
elif filename.endswith('.dta'):
  df = pd.read_stata(filename)
elif filename.endswith('.feather'):
  df = pd.read_feather(filename)
else:
  raise ValueError(f'cannot determine file type of {filename}!')
EOF

PYTHONSTARTUP=$tempscript jupyter qtconsole
rm $tempscript