Iterating Through Data Frame Rows

[Pedroski55]

Not being a scientist, I don't have any large amounts of experimental data to process, but pandas is interesting!

Have a look here perhaps!

import pandas as pd

# open the file
xl_file = '/home/pedro/myPython/pandas/delete_row.xlsx'
df = pd.read_excel(xl_file)

"""
>>> df
   col1  col2  col3  col4  col5  col6
0   123     1     2     3     4     5
1   123     2     3     4     5     6
2   456     3     4     5     6     7
3   456     4     5     6     7     8
4   789     5     6     7     8     9
5   789     6     7     8     9    10
6   123     7     8     9    10    11

"""

# Drop a row by condition

df2 = df[df.col1 != 123]

"""
>>> df2
   col1  col2  col3  col4  col5  col6
2   456     3     4     5     6     7
3   456     4     5     6     7     8
4   789     5     6     7     8     9
5   789     6     7     8     9    10
>>>
"""