Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- df_CaveIns = pd.read_csv("DEP_Cave_in_CARs.csv")
- def createAddress(row):
- for row in df_CaveIns['Permit']:
- if row[0] == 'Q':
- return df_CaveIns['On_Street_Name'] + ' ' + 'AND' + ' ' + df_CaveIns['To_Street_Name'] + ',' + ' ' + 'QUEENS' + ' ' + 'NEW YORK'
- elif row[0] == 'S':
- return df_CaveIns['On_Street_Name'] + ' ' + 'AND' + ' ' + df_CaveIns['To_Street_Name'] + ',' + ' ' + 'STATEN ISLAND' + ' ' + 'NEW YORK'
- elif row[0] == 'M':
- return df_CaveIns['On_Street_Name'] + ' ' + 'AND' + ' ' + df_CaveIns['To_Street_Name'] + ',' + ' ' + 'MANHATTAN' + ' ' + 'NEW YORK'
- elif row[0] == 'B':
- return df_CaveIns['On_Street_Name'] + ' ' + 'AND' + ' ' + df_CaveIns['To_Street_Name'] + ',' + ' ' + 'BROOKLYN' + ' ' + 'NEW YORK'
- elif row[0] == 'X':
- return df_CaveIns['On_Street_Name'] + ' ' + 'AND' + ' ' + df_CaveIns['To_Street_Name'] + ',' + ' ' + 'BRONX' + ' ' + 'NEW YORK'
- df_CaveIns['Address'] = df_CaveIns.apply(createAddress, axis=1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement