Concatenate two columns in 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

I want to concatenate CityArrival and CountryArrival.

You mean to combine them into one column?

Iron Fist
– Iron Fist

2015-12-01 18:33:36 +00:00
Commented Dec 1, 2015 at 18:33 — Iron Fist
– Iron Fist, Commented Dec 1, 2015 at 18:33

Stefan · Accepted Answer · 2015-12-01 18:34:45Z

2

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

answered Dec 1, 2015 at 18:34

Stefan

43.1k13 gold badges80 silver badges84 bronze badges

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

3 Comments

Payne Over a year ago

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

Payne Over a year ago

import pandas as pd import datetime import pandas.io.data from pandas_datareader import data, wb df = pd.read_csv('testfile.csv') df['Arrival'] = df.CityArrival + ' ' + df.CountryArrival print df

Stefan Over a year ago

And what's the problem?

triphook · Accepted Answer · 2015-12-01 18:37:33Z

1

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

answered Dec 1, 2015 at 18:37

triphook

3,1073 gold badges28 silver badges38 bronze badges

2 Comments

Payne Over a year ago

Thanks for your quick response, I have another question. From the "Arrival". I want to create dictionary using each value under the arrival (e.g. ParisFrance = { 2001-02-01: [1922]}) so that date will be the key while any of the authorid that fall within the date will be added to the list.

triphook Over a year ago

Use collections.defaultdict for this. You can initialize a dictionary like "travel_dict = defaultdict(lambda: defaultdict(list))", then add values like "travel_dict["ParisFrance"]["2001-02-01"].append(1922)"

Milovan Tomašević · Accepted Answer · 2022-02-04 12:12:06Z

1

Try this:-

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

# update file
df.to_csv('final.csv', encoding='utf-8-sig', index=False)

edited Feb 4, 2022 at 12:12

Milovan Tomašević

8,9712 gold badges58 silver badges49 bronze badges

answered Jun 14, 2018 at 6:45

Shekhar

331 silver badge8 bronze badges

1 Comment

Milovan Tomašević Over a year ago

Ty for .map(str) !

Collectives™ on Stack Overflow

Concatenate two columns in CSV: Python

3 Answers 3

3 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related