How to add values to column using loop Pandas

Question

I would like to know how I can change the values of a column dynamically as I grab the information from a web scrape.

Currently, I have something like this:

number name 12 NA 13 NA 14 NA 15 NA

and I would like to receive something like this:

number name 12 Mike 13 Bob 14 Bobby 15 Mark

I have tried using this: for number in phone_book: name = get_name() phonebook['names'][number] = name

and

phonebook.loc[phonebook.index[number], 'name'] = name

but it just sets the name of the last number for all:

number name 12 Mark 13 Mark 14 Mark 15 Mark How could I get it to add each name to its respective number?

Thanks

@QuangHoang Thank you so much, that works! Can you explain why I need the phonebook.number == number? — Bryan Camacho
– Bryan Camacho, Commented Nov 12, 2019 at 18:31
phonebook.number == number looks through the 'number' columns in your phonebook and mark the correct ones. .loc gives you access to the corresponding rows/columns. — Quang Hoang
– Quang Hoang, Commented Nov 12, 2019 at 18:32

DisappointedByUnaccountableMod · Accepted Answer · 2021-02-14 13:03:31Z

2

From your web scrape you could build a dict that looks like this:


name = {12: 'Mike', 13: 'Bob', 14: 'Bobby', 15: 'Mark'}

Then you can map to your existing frame:

df['name']=df['number'].map(name)
df = df.set_index('number')
print(df) 
         
number   name    
12       Mike
13        Bob
14      Bobby
15       Mark

edited Feb 14, 2021 at 13:03

DisappointedByUnaccountableMod

6,8444 gold badges21 silver badges23 bronze badges

answered Nov 12, 2019 at 18:32

oppressionslayer

7,2242 gold badges11 silver badges26 bronze badges

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

Comments

Florian Bernard · Accepted Answer · 2019-11-12 18:27:12Z

0

You have several way to do it, first like @Quang Hoang comment :

phonebook.loc[phonebook.number == number, 'names'] = name

You can also do like this :

for number in phone_book:
    name = get_name()
    phonebook[phonebook["number"] == number] = name

or like this :

names = []
for number in phone_book:
    names.append(get_name())
phonebook["name"] = names

Note that the prefered method is the first one.

answered Nov 12, 2019 at 18:27

Florian Bernard

2,5891 gold badge11 silver badges24 bronze badges

Collectives™ on Stack Overflow

How to add values to column using loop Pandas

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related