How to create a column containing whitespace using assign() method in Pandas

Question

Sample Data:

import pandas as pd

df1=pd.DataFrame({'Original City': {'Daimler': 'Chicago',
  'Mitsubishi': 'LA',
  'Tesla': 'Vienna',
  'Toyota': 'Zurich',
  'Renault': 'Sydney',
  'Ford': 'Toronto'}})

df2=pd.DataFrame({'Current City': {'Tesla': 'Amsterdam',
  'Renault': 'Paris',
  'BMW': 'Munich',
  'Fiat': 'Detroit',
  'Audi': 'Berlin',
  'Ferrari': 'Bruxelles'}})

Now my question is:

I am trying to create a column containing whitespace using assign() method:

df1.assign(Original City=df2['Current City'])
                   ^
               #white space

I tried:

df1.assign('Original City'=df2['Current City'])
df1.assign(r'Original City'=df2['Current City'])

And as expected It is giving me an error:

  File "<ipython-input-132-2ac564ac9d47>", line 1
    df1.assign(Original City=df2['Current City'])
                        ^
SyntaxError: invalid syntax

But I can able to assign my column like this:

df1.assign(OriginalCity=df2['Current City'])

Is it possible to create a column containing ' ' space(white space) using assign() method?

Having spaces in identifiers are not allowed. dict(a=1) works but dict(a b=1) doesnot — anky
– anky, Commented Apr 20, 2021 at 14:30
@anky Thanks for the information....I also thinked this but I was wondering that Is there a way for doing so :) — Anurag Dabas
– Anurag Dabas, Commented Apr 20, 2021 at 14:34
Does this answer your question? pandas assign with new column name as string — ouroboros1
– ouroboros1, Commented Apr 30, 2024 at 12:27

Quang Hoang · Accepted Answer · 2021-04-20 14:19:27Z

6

You can use unpack dictionary:

d = {'Original City':df2['Current City']}
df1.assign(**d)

Or unpack a dataframe:

df1.assign(**df2[['Current City']].rename({'Current City': 'Original City'}))

answered Apr 20, 2021 at 14:19

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

1 Comment

Anurag Dabas Over a year ago

Thanks @Quang Hoang....I was thinking to ask this question from many past days

Collectives™ on Stack Overflow

How to create a column containing whitespace using assign() method in Pandas

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related