text_plain_output_1.png
import pandas as pd

daily_activities = pd.read_csv('../input/fitbit/Fitabase Data 4.12.16-5.12.16/dailyActivity_merged.csv')
daily_calories = pd.read_csv('../input/fitbit/Fitabase Data 4.12.16-5.12.16/dailyCalories_merged.csv')
daily_intensities = pd.read_csv('../input/fitbit/Fitabase Data 4.12.16-5.12.16/dailyIntensities_merged.csv')
daily_steps = pd.read_csv('../input/fitbit/Fitabase Data 4.12.16-5.12.16/dailySteps_merged.csv')
hourly_steps = pd.read_csv('../input/fitbit/Fitabase Data 4.12.16-5.12.16/hourlySteps_merged.csv')
hourly_intensities = pd.read_csv('../input/fitbit/Fitabase Data 4.12.16-5.12.16/hourlyIntensities_merged.csv')
sleep_day = pd.read_csv('../input/fitbit/Fitabase Data 4.12.16-5.12.16/sleepDay_merged.csv')
weight_index = pd.read_csv('../input/fitbit/Fitabase Data 4.12.16-5.12.16/weightLogInfo_merged.csv')

len(weight_index.Id.unique())

len(daily_activities.Id.unique())

len(sleep_day.Id.unique())

sleep_day.columns = ['Id', 'Date', 'TotalSleepRecords', 'TotalMinutesAsleep', 'TotalTimeInBed']
daily_activities.columns = ['Id', 'Date', 'TotalSteps', 'TotalDistance', 'TrackerDistance', 'LoggedActivitiesDistance', 'VeryActiveDistance', 'ModeratelyActiveDistance', 'LightActiveDistance', 'SedentaryActiveDistance', 'VeryActiveMinutes', 'FairlyActiveMinutes', 'LightlyActiveMinutes', 'SedentaryMinutes', 'Calories']

sleep_day.Date = pd.to_datetime(sleep_day['Date'], format='%m/%d/%Y %I:%M:%S %p').dt.strftime('%m/%d/%Y')
daily_activities.Date = pd.to_datetime(daily_activities['Date'], format='%m/%d/%Y').dt.strftime('%m/%d/%Y')
weight_index.Date = pd.to_datetime(weight_index['Date'], format='%m/%d/%Y %I:%M:%S %p').dt.strftime('%m/%d/%Y')

daily_activities.describe()