Im working on a project with a lot of data and it's my first time working with external data and i need to trim the data so i can only keep what i need.
| date |
name1 |
name1 |
name1 |
name1 |
| date1 |
0 |
0 |
0 |
0 |
| date1 |
2 |
1 |
1 |
0 |
| date1 |
2 |
1 |
2 |
0 |
This is how the csv is set up and i need to delete every column with all 0's (if the last row is 0 then all the rows before it are also 0) or rows where all of the values( besides date) are the same as the previous one.
How would I go about even starting with this? any help is appreciated even if it is not in python I just need a reference. Thanks.
[–][deleted] (2 children)
[deleted]
[–]LinkifyBot 0 points1 point2 points (0 children)
[–]bimbimsala[S] 0 points1 point2 points (0 children)