I have a DataFrame and I would like to drop the last column of it. Until now I had just been dropping what I believed to be the final column with
if len(fish_frame.columns) == 4:
del fish_frame[3].
Right before this command, however, I drop all columns of NaNs. So that removes column [3] because it is filled with NaNs, so it fails.
I would like to say just drop the final column of the entire DataFrame. I feel like that would work perfectly.
I tried fish_frame([:-1], axis=1) but that's invalid syntax.
Any help would be appreciated thanks.
The DataFrame:
fish_frame after dropna:
0 1 2 4
0 #0721 NaN NaN NaN
1 GBE COD 746 $2.00 $1,492.00
2 GBW COD 13,894 $0.50 $6,947.00
3 GOM COD 60 $2.00 $120.00
4 GB WINTER FLOUNDER 94,158 $0.25 $23,539.50
5 GOM WINTER FLOUNDER