hello everyone I have two data sets I'm trying to first clean up and then combine into one data frame for exporting. My data is scrapped from a webpage and this is the result called df1 and df2. my first problem is the data keeps coming back with the first column I have labeled (blank) is just an empty cell with nothing in it and 0 both of which are useless and I want to remove.
EDIT: thanks to @richardec This worked for the first df1 removing the blank and 0 altogether. But didn't solve it for df2.
What i had to do was
and it worked for df2
df1 = (Blank) Item Quantity Date 0 disposable cups 7000 07/01/22 df2= (blank) Order Number 0 A-21-897274
What I've tried:
df1.reset_index() df1.drop_na(inplace=True) df1 = df1.drop(0, axis=1)
none of these have worked for me. Any help cleaning up this data would be greatly appreciated so that when its brought to excel there isn't a blank space and 0 listed.