Deleting empty columns with a few columns between data

Asked Mar 20 '22 at 01:39

Active Mar 20 '22 at 01:43

Viewed 40 times

I'm fetching data from a Google sheet:

values1 = pd.DataFrame(values)
aux = values1.head(1)
values1.drop(index={0}, inplace=True)
senal1 = (values1[2] == "SEÑAL")
senal = values1[senal1]
senal.dropna(axis=1, inplace=True)
print(senal)

This is my result after running the code:

edited Mar 20 '22 at 01:43

Christian

4,902
4
24
42

asked Mar 20 '22 at 01:39

Iván David Rodríguez Amézquita

This is what I'm getting https://i.stack.imgur.com/oza9N.png – Iván David Rodríguez Amézquita Mar 20 '22 at 01:43
1

Hey, welcome to SO. I [fixed the question formatting](https://stackoverflow.com/posts/71543417/revisions). I think the result is included now. I think your initial data set and the expected result aremissing. – Christian Mar 20 '22 at 01:44
1

Try `senal.dropna(axis=1, thresh=len(senal[0]), inplace=True)` – Mar 20 '22 at 01:58

Deleting empty columns with a few columns between data

0 Answers0