GCP

# Cell 1
import pandas as pd
import os, sys
response_data = pd.read_csv('Downloads/Fire_Rescue_Responses.csv')
response_data.head()
rd_addr_loc = response_data['Location Address'].str.split('\n', 1, expand=True)
rd_addr_loc.columns = ['Address', 'Location']

rd_date = response_data['Response Date'].str.split(' ', 1, expand=True)
rd_date.columns = ['Date', 'Time']
rd = pd.merge(response_data, rd_addr_loc, right_index=True, left_index=True)
rd = pd.merge(rd, rd_date, right_index=True, left_index=True)
rd = rd[['Date', 'Response Type', 'Location Name', 'Address', 'Location']]
rd.to_csv('Downloads/responses.csv')
rd.head()

EMS Calls	FIRE Calls	ALM Calls	SVC Calls	HAZ Calls

EMS Calls 1.000000 0.848759 0.525009 0.716986 0.808898
FIRE Calls 0.848759 1.000000 0.696650 0.571377 0.820447
ALM Calls 0.525009 0.696650 1.000000 0.331825 0.443817
SVC Calls 0.716986 0.571377 0.331825 1.000000 0.699963
HAZ Calls 0.808898 0.820447 0.443817 0.699963 1.000000