def write_db(dataset): if dataset.empty: print("No data to insert into database") else: #dataset.to_csv("Agg_Data.csv",index=False) dest_table=GuruTable(table_name='ura_private_units_sold') dest_table.truncate() for i in range(len(dataset)): insert_row(dataset.iloc[i],dest_table)
def insert_row(row): dest_table=GuruTable(table_name='ura_private_units_sold') #print(row) dest_table.insert().values( year=row["year"], month=row["month"], developer=row["Developer"], property_type=row["Property Type"], locality=row["Locality"], street_name=row["Street Name"], project_name=row["Project Name"], total_units_projects=row["Total Number of Units in Project"], cumulative_units_launched=row["Cumulative Units Launched to-date"], cumulative_units_sold=row["Cumulative Units Sold to-date"], total_unsold_units=row["Total Number of Unsold Units"], cumulative_units_launched_unsold=row["Cumulative Units Launched but Unsold"], units_launched_month=row["Units Launched in the Month"], units_sold_month=row["Units Sold in the Month"], median_price_psf_month=row["Median Price ($psf) # in the Month"], lowest_price_psf_month=row["Lowest Price ($psf) # in the Month"], highest_price_psf_month=row["Highest Price ($psf) # in the Month"], modified_date=dt.datetime.now() ).execute()