Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
PANDAS
#3
(Nov-27-2022, 06:42 PM)snippsat Wrote:
(Nov-27-2022, 04:55 PM)astral_travel Wrote: for some reason it gives one more column info, even though this column is not visible...(nor exists to the best of my knowledge)...
It can come from empty data from file you read in.
Do df.columns will show all columns.
To clean up.
df.drop(df.filter(regex="Unname"), axis=1, inplace=True)

okay, it sure shows it, but it does not show in the file....here's the output:

Output:
Index(['unnamed', 'Ticker', 'Description', 'Unnamed: 3'], dtype='object')
and attached is the file
Reply


Messages In This Thread
PANDAS - by astral_travel - Nov-27-2022, 04:55 PM
RE: PANDAS - by snippsat - Nov-27-2022, 06:42 PM
RE: PANDAS - by astral_travel - Nov-27-2022, 08:56 PM
RE: PANDAS - by snippsat - Nov-27-2022, 09:21 PM
RE: PANDAS - by astral_travel - Nov-27-2022, 10:08 PM
RE: PANDAS - by snippsat - Nov-27-2022, 10:22 PM
RE: PANDAS - by astral_travel - Nov-27-2022, 10:48 PM
RE: PANDAS - by snippsat - Nov-27-2022, 11:26 PM
RE: PANDAS - by astral_travel - Nov-28-2022, 08:06 PM
RE: PANDAS - by Larz60+ - Nov-28-2022, 09:39 PM
RE: PANDAS - by astral_travel - Nov-29-2022, 04:55 PM
RE: PANDAS - by Larz60+ - Nov-29-2022, 05:55 PM

Forum Jump:

User Panel Messages

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