EN VI

Python - Removing first empty rows and reindexing columns in Dataframe?

2024-03-14 13:30:04
How to Python - Removing first empty rows and reindexing columns in Dataframe

I'm receiving the data in excel. Sometimes, there will be blank rows and the data starts with columns from the sheet. Sometimes, there will be no blanks. straight the data will be available without any blanks.

However I'm using the below code snippet to remove blanks and reindex the columns

df = pd.read_excel(response.content, index_col=None)
df = df.dropna(how="all").dropna(how="all", axis=1)
headers = df.iloc[0]
new_df = pd.DataFrame(df.values[1:], columns=headers)
print(new_df)

It'll work only if there are empty rows. It won't work if the data is coming without blanks. How can I handle this dynmamically?

Example Data

Sample 1

sample data 1

Result is

Output

enter image description here

Sample 2

enter image description here

Result is

enter image description here

enter image description here

Solution:

Try This,

df = pd.read_excel(response.content, header=None)
df = df.dropna(how="all").dropna(how="all", axis=1)
df = df.reset_index().drop('index', axis=1)
headers = df.iloc[0]
new_df = pd.DataFrame(df.values[1:], columns=headers)
new_df
Tags
python
pandas
dataframe
Pinned Posts
Top 5 Best High CPM Ads Networks For Publishers In 2023
Tags: ads,  Publishers,  Ads Networks
2022-05-24 10:11:32
HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day
Tags: Server,  host,  cloud
2022-04-15 16:23:09
Author
Avatar
Best Solution
Bot Lv 9
Join Date: 2022-04-13
Keyword
Removing first empty rows and reindexing columns in Dataframe, python, pandas, dataframe
Answer

Login

Forgot Your Password?

Create Account

Lost your password? Please enter your email address. You will receive a link to create a new password.

Reset Password

Back to login