Skip to content

Instantly share code, notes, and snippets.

@Akramz
Created December 15, 2015 16:04
Show Gist options
  • Save Akramz/e0b95d7eab0db9044488 to your computer and use it in GitHub Desktop.
Save Akramz/e0b95d7eab0db9044488 to your computer and use it in GitHub Desktop.
import pandas as pd
import numpy as np
from sys import exit
data = pd.read_csv('../../data/train.csv', sep=',')
train = data[['Address']]
train = train.loc[train['Address'].str.contains(' / ')]
train['count'] = 1
train = train.groupby('Address').sum().reset_index()
print len(train)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment