I have some tables where the first 11 columns are populated with data, but all columns after this are blank. I tried:
which didn't work. I then used:
df = df.drop(df.columns[range(11,36)], axis=1)
Which worked on the first few tables, but then some of the tables were longer or shorter and so this generated error messages.
How can I either drop completely empty columns or delete all columns bar the first 11?