Insert a new column based on condition in each row

Asked Apr 13 '21 at 11:11

Active Apr 13 '21 at 13:08

Viewed 80 times

I have a dataset that contains these values.

Game        
Cricket     
Football    
Basketball  
Snooker     
Bowling     
Baseball    
Cricket     
Football    
Basketball  
Snooker     
Bowling

I want to create a new column[Type] based on the values in the Game as below Cricket, Football, Basketball should be classified as "Asia" while other games should be classified as "Europe.

Game         Type
Cricket      Asia
Football     Asia
Basketball   Asia
Snooker      Europe 
Bowling      Europe 
Baseball     Asia
Cricket      Asia
Football     Asia
Basketball   Asia

I always get the error "Value Error:- Length of values 14 does not match the index:- 2254

edited Apr 13 '21 at 13:05

asked Apr 13 '21 at 11:11

Steve Kundukulangara

What is the condition? It's not clear how the mapping happens – David Apr 13 '21 at 11:14
create dict like `d = {'Cricket':'Asia', ..}` and then use `map` – jezrael Apr 13 '21 at 11:16
Length of values (14) does not match the length of index (2295). I tried to use a dictionary and check but got the following error. I have been getting this error since... I believe I have to use some loop to fix this but not sure how. – Steve Kundukulangara Apr 13 '21 at 11:30
@SteveKundukulangara - added new dupe for solution. – jezrael Apr 13 '21 at 13:08
@jezrael I didn't quite get that? Can you elaborate please? – Steve Kundukulangara Apr 13 '21 at 13:18
1

I think [this](https://stackoverflow.com/questions/45184549/python-pandas-new-columns-value-if-the-item-is-in-the-list) solution. – jezrael Apr 13 '21 at 13:19
1

@jezrael. Thanks a lot sir. 5 days that's how many days I have been working on to get the solution. You are a true gem. really appreciate it. – Steve Kundukulangara Apr 13 '21 at 13:41
@jezrael, does this work for multiple conditions? I have more than one condition and want to apply in it – Steve Kundukulangara Apr 28 '21 at 13:25

Insert a new column based on condition in each row

0 Answers0