right way to add values in empty column in loop in dataframe , python

Question

df=pd.DataFrame[columns='one','two','three']

for home in city:
    adres= home
    for a in abc: #abc is pd.Series od names
        #here i want to add values - adress and a , but my dataframe have 3 columns, i will use only 2 here
         df.loc[len(df)]= [adres, a, np.nan]
          print(df)

one, two, three
alabama, flat, NaN

How propery should i add values adres and a to one and two column in df and leave column three untouchable?

thank you

anky · Accepted Answer · 2019-05-17 12:07:03Z

1

I think you are looking for something like:

for i in range(1):
    df.loc[i,['one','two']]=['adress','a']
print(df)

      one two three
0  adress   a   NaN

answered May 17, 2019 at 12:07

anky

75.3k11 gold badges46 silver badges76 bronze badges

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

Comments

kendhia · Accepted Answer · 2019-05-17 12:08:23Z

0

I would first create a pandas series that contain the values and columns I want. for example:

new_values= pd.Series(["a", "b"], index=["one", "two"])

Then I would append this series to the original dataframe:

df= df.append(new_values, ignore_index=True)

answered May 17, 2019 at 12:08

kendhia

2993 silver badges14 bronze badges

Collectives™ on Stack Overflow

right way to add values in empty column in loop in dataframe , python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related