Detect data within csv column with python

Question

I have this following csv and it looks like this:

I want to detect if there is any cells that are more than 1.25 in values.

I have tried using this code but it seems wrong. Any ideas? (I use loop because it's more than 1 csv)

dflist = []
for i, file in enumerate(flist):
    df = pd.read_csv(file, skiprows = [0,1,3,4])
    dflist.append(df)
    if df.iloc[:,45:52].values.flatten()[i] >= 1.2:
        print([i],'Hard Landing')
    else:
        print([i],'Normal Flight')

kindly share data, not pics. use this as a guide

sammywemmy
– sammywemmy

2020-03-28 11:02:30 +00:00
Commented Mar 28, 2020 at 11:02 — sammywemmy
– sammywemmy, Commented Mar 28, 2020 at 11:02

Muhammad Danial Khan · Accepted Answer · 2020-03-30 19:15:28Z

0

You can simply use df.values function of pandas. It returns a numpyarray.

    x = df.values
    w = list(map(float,x))
    y = w[w>1.25]
    if y.size != 0:
      print("Greater Value Exist")

edited Mar 30, 2020 at 19:15

answered Mar 27, 2020 at 21:25

Muhammad Danial Khan

3989 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ojasony Over a year ago

i got an error, TypeError: '>' not supported between instances of 'str' and 'float'

Muhammad Danial Khan Over a year ago

Convert the list to float. I have updated the answer.

Collectives™ on Stack Overflow

Detect data within csv column with python

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related