在CSV:Python中连接两列

Question

AuthorID    CityArrival CountryArrival  Departure   CountryDeparture    DateDeparture   DateArrival
1922    Paris   France  New York    UnitedState 2008-03-10  2001-02-02
1002    LosAngeles  UnitedState California  UnitedState 2008-03-10  2008-12-01
1901    Paris   France  Lagos   Nigeria 2001-03-05  2001-02-02
1922    Paris   France  NewYork UnitedState 2011-02-03  2008-12-01
1002    Paris   France  California  UnitedState 2003-03-04  2002-03-04
1099    Paris   France  Beijing China   2011-02-03  2009-02-04
1901    LosAngeles  UnitedState Paris   France  2001-03-05  2001-02-02

我想连接CityArrival和CountryArrival。在

Answer 1

试试看这：

import pandas as pd
df = pd.read_csv(path)
df['Arrival'] = df['CityArrival'].map(str) + ' ' + df['CountryArrival'].map(str)

Answer 2

import pandas as pd
df = pd.read_csv(path)
df['Arrival'] = df.CityArrival + ' ' + df.CountryArrival

Answer 3

import csv    
with open(path) as f:
    reader = csv.DictReader(path)
    for line in reader:
        arrival = "{}, {}".format(line['CityArrival'], line['CountryArrival'])