My issue is much. I have a csv file, and want to select where Arrival or Departure and must be the same "date and time" have the same value. I can only read from csv file but can't go further
import pandas as pd df = pd.read_csv("data.csv") row = next(df.iterrows()) print(row['x'])
error: dataframe is not defined.
I have a cvs file with 5 columns and multiple rows, as shown below:
Author_ID Arrival Departure Date Time 01202 Paris New York 10/03/2011 10:00 02122 Beijin New York 09/03/1999 21:00 07732 Paris Kansas 10/03/2011 10:00 from the table above you can discover that some column values match. I want to extract wherever I find intersection. e.g so as we iterate whenever we encounter a row with the same values in Arrival or Depature or Author_ID and date && Time, we should extract and display Take Arrival column, we have Paris from 2 different Authors, then consider the Date we have 10/03/2011 and "Time" we have 10:00. We want to know if these authors have connections with their depatures, arrivals at particular date and time.
Basically, I think I don't know how to go about it