image_output_1.png
import pandas as pd

import pandas as pd
import numpy as np
import seaborn as sns
baseDir = '../input/'
people = pd.read_csv('{0}people.csv'.format(baseDir)).drop_duplicates()
act_train = pd.read_csv('{0}act_train.csv'.format(baseDir)).drop_duplicates()
act_test = pd.read_csv('{0}act_test.csv'.format(baseDir)).drop_duplicates()

print('{0} duplicate people rows'.format(people.drop('people_id', axis=1).duplicated().sum()))
print('{0} duplicate people ids'.format(people['people_id'].duplicated().sum()))
print('{0} duplicate train rows'.format(act_train.drop('activity_id', axis=1).duplicated().sum()))
print('{0} duplicate train rows with different outcome'.format(act_train.drop(['activity_id'], axis=1).drop_duplicates().drop('outcome', axis=1).duplicated().sum()))
print('{0} duplicate train activity id'.format(act_train['activity_id'].duplicated().sum()))
print('{0} duplicate test rows'.format(act_test.drop('activity_id', axis=1).duplicated().sum()))
print('{0} duplicate test activity id'.format(act_test['activity_id'].duplicated().sum()))