How to print results in dataframe format after using a for loop

Question

I am analyzing some data. I got my for loop to print in array format but i wanted to print the results back in a data frame format as i am working with data frames.

import itertools 

for time, flight in itertools.izip(flight_data["AirTime"], flight_data["UniqueCarrier"]):
    if time > 300:
        print (time, flight)
Outputs:(340, AA)

However, I want the output to return back in a dataframe format. Please assist thanks

jezrael · Accepted Answer · 2016-10-27 14:09:43Z

2

Use boolean indexing:

print (flight_data[flight_data.AirTime > 300])

Sample:

flight_data = pd.DataFrame({'AirTime':[340,200,110],
                            'UniqueCarrier':['AA','SS','DD']})

print (flight_data)
   AirTime UniqueCarrier
0      340            AA
1      200            SS
2      110            DD


print (flight_data[flight_data.AirTime > 300])
   AirTime UniqueCarrier
0      340            AA

answered Oct 27, 2016 at 14:09

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

How to print results in dataframe format after using a for loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related