Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. import pandas as pd
  2. df_CaveIns = pd.read_csv("DEP_Cave_in_CARs.csv")
  3.  
  4. def createAddress(row):
  5. for row in df_CaveIns['Permit']:
  6. if row[0] == 'Q':
  7. return df_CaveIns['On_Street_Name'] + ' ' + 'AND' + ' ' + df_CaveIns['To_Street_Name'] + ',' + ' ' + 'QUEENS' + ' ' + 'NEW YORK'
  8. elif row[0] == 'S':
  9. return df_CaveIns['On_Street_Name'] + ' ' + 'AND' + ' ' + df_CaveIns['To_Street_Name'] + ',' + ' ' + 'STATEN ISLAND' + ' ' + 'NEW YORK'
  10. elif row[0] == 'M':
  11. return df_CaveIns['On_Street_Name'] + ' ' + 'AND' + ' ' + df_CaveIns['To_Street_Name'] + ',' + ' ' + 'MANHATTAN' + ' ' + 'NEW YORK'
  12. elif row[0] == 'B':
  13. return df_CaveIns['On_Street_Name'] + ' ' + 'AND' + ' ' + df_CaveIns['To_Street_Name'] + ',' + ' ' + 'BROOKLYN' + ' ' + 'NEW YORK'
  14. elif row[0] == 'X':
  15. return df_CaveIns['On_Street_Name'] + ' ' + 'AND' + ' ' + df_CaveIns['To_Street_Name'] + ',' + ' ' + 'BRONX' + ' ' + 'NEW YORK'
  16.  
  17. df_CaveIns['Address'] = df_CaveIns.apply(createAddress, axis=1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement