'pandas data cleaned up and combined help? python

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.

df1= df1.set_index('Item') 

What i had to do was

df2.to_excel('df2.xlsx', index=False)

and it worked for df2

Orgininal Code:

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.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source