Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Cannot rename Columns in df
#5
Thank you for looking into it!
The Excel file I'm reading has usually 2 first rows blank sometimes more. I'd like to completely remove blank rows.
When I used your code:
exlf = pd.read_excel('C:/01/XLS_Files/SHORT.xlsx', usecols=lambda x: 'Unnamed' not in x)
print(exlf)
it produces:
Empty DataFrame
Columns: []
Index: []
I'm getting really frustrated with this, it is such a simple tusk Confused . Should I try different modules?
Thank you.
Reply


Messages In This Thread
Cannot rename Columns in df - by tester_V - Aug-25-2023, 04:59 PM
RE: Cannot rename Columns in df - by deanhystad - Aug-25-2023, 05:16 PM
RE: Cannot rename Columns in df - by tester_V - Aug-25-2023, 06:30 PM
RE: Cannot rename Columns in df - by snippsat - Aug-25-2023, 06:59 PM
RE: Cannot rename Columns in df - by tester_V - Aug-25-2023, 07:38 PM
RE: Cannot rename Columns in df - by snippsat - Aug-25-2023, 08:01 PM
RE: Cannot rename Columns in df - by tester_V - Aug-25-2023, 10:34 PM
RE: Cannot rename Columns in df - by snippsat - Aug-26-2023, 12:28 AM
RE: Cannot rename Columns in df - by deanhystad - Aug-26-2023, 01:16 AM
RE: Cannot rename Columns in df - by tester_V - Aug-26-2023, 03:50 AM
RE: Cannot rename Columns in df - by deanhystad - Aug-26-2023, 10:40 PM
RE: Cannot rename Columns in df - by perfringo - Aug-27-2023, 06:10 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to rename dataframe columns based on the content in an index? ar_mahdavi 2 2,605 Jun-07-2021, 06:09 AM
Last Post: ricslato

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020