def get_aws_station_info():
'''Bring in station information and assign cluster to each '''
# Connect to AWS
conn, cur = uf.aws_connect()
# Query cabi_region - note that longitute should always come first to generate a geographic Point
stations_df = pd.read_sql(
"""SELECT lon, lat, name, short_name, name from cabi_stations_temp""",
con=conn)
return stations_df
incwage integer,
pwstate2 integer,
tranwork integer,
carpool integer,
riders integer,
trantime integer,
qtrantim integer,
qtranwor integer)
)
""")
if __name__ == "__main__":
# Connect to AWS
uf.set_env_path()
conn, cur = uf.aws_connect()
# Load CSV FROM IPMUS Download as Dataframe
csv_name = 'usa_00007'
acs_df = pd.read_csv(csv_name + ".csv")
# Set Primary Key
acs_df.reset_index(inplace=True)
# Fill all na with zeros
acs_df.fillna(0, inplace=True)
# Output dataframe as CSV
outname = csv_name + "_pipe_delimited"
acs_df.to_csv(outname + ".csv", index=False, sep='|')
# Create Database
create_acs(cur)
# Load to Database
uf.aws_load(outname, "acs", cur)
# Commit changes to database
