Munges stuff from FitNotes, StrongLifts and MyFitnessPal

mungeall.py

import pandas as pd
import numpy as np

fitnotesFile = "..."
strongLiftsFile = "..."
mfpFile = "..."

fn = pd.read_csv(fitnotesFile)
fn = fn.rename(columns={'Weight (kgs)': 'Weight'}) # cleanup names
grp = fn.groupby(['Date','Exercise']).agg({'Weight':[np.sum, np.mean], 'Reps': [np.sum, np.mean], 'Exercise': [np.size]})
unstacked = grp.unstack()

colNames = []
for c in unstacked.columns:
	if c[0] == 'Exercise':
		colNames.append('{} Sets'.format(c[2]))
	else:
		colNames.append('{} {}({})'.format(c[2], c[1], c[0]))

unstacked.columns = colNames
unstacked = unstacked.reset_index()

sl = pd.read_csv(strongLiftsFile) # already unstacked
workouts = pd.concat([sl, unstacked])

weights = pd.read_csv(mfpFile)
together = pd.merge(weights, workout, on='Date', how='left')