rrosasl · November 25, 2020 17:10 · rrosasl · Aug 30, 2021 · capncrockett · Sep 1, 2021
diff --git a/cleaning_g_sheet.py b/cleaning_g_sheet.py
 # Convert Rows into DataFrame and clean data
 new_header = df.iloc[0] #grab the first row for the header
 df = df[1:] #take the data less the header row
 df.columns = new_header #set the header row as the df header
 df = df.iloc[:,1:] # Remove time stamp

 # Convert to a DataFrame and render.
 df = pd.DataFrame.from_records(rows)

 new_header = df.iloc[0] #grab the first row for the header
 df = df[1:] #take the data less the header row
 df.columns = new_header #set the header row as the df header
 df = df.iloc[:,1:] # Remove time stamp

 #Convert votes to int
 for col in df.columns:
  df[col] = pd.to_numeric(df[col])
 #Change column names to candidate
 votes = []
 for col in df.columns: 
  name = col[37:-1]
  votes.append(name)
 df.columns = votes
 df = df.reset_index().iloc[:,1:]
	# Convert Rows into DataFrame and clean data
	new_header = df.iloc[0] #grab the first row for the header
	df = df[1:] #take the data less the header row
	df.columns = new_header #set the header row as the df header
	df = df.iloc[:,1:] # Remove time stamp

	# Convert to a DataFrame and render.
	df = pd.DataFrame.from_records(rows)

	new_header = df.iloc[0] #grab the first row for the header
	df = df[1:] #take the data less the header row
	df.columns = new_header #set the header row as the df header
	df = df.iloc[:,1:] # Remove time stamp

	#Convert votes to int
	for col in df.columns:
	df[col] = pd.to_numeric(df[col])
	#Change column names to candidate
	votes = []
	for col in df.columns:
	name = col[37:-1]
	votes.append(name)
	df.columns = votes
	df = df.reset_index().iloc[:,1:]