Nov-27-2022, 08:56 PM
(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.
Dodf.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