Pandas adding values into the dataframe

Question

Here is my code where I'm trying to add/append new values to the third column:

        file = 'excel_name.xlsx'
        df = pd.read_excel(file, engine='openpyxl')
        print(df)
        df.insert(3, 'sub', [1, 7, 4, 1])
        print('test', df)

the output of print(df):

                      name  ...         sub
0                     test1  ...        NaN
1                     test2  ...        NaN
2                     test3  ...        NaN
3                     test4  ...        NaN

What I want to do:

                      name  ...         sub
0                     test1  ...        1
1                     test2  ...        7
2                     test3  ...        4
3                     test4  ...        1

Does your output come from the first print statement or the second? — Leonardo Boscolo
– Leonardo Boscolo, Commented Jul 15, 2022 at 9:32
Please check out this solution : stackoverflow.com/a/51561012/8352083 — ZeroOne
– ZeroOne, Commented Jul 15, 2022 at 9:41

Berlin Benilo · Accepted Answer · 2022-07-15 09:48:36Z

2

you can use this. This will work for both even and uneven length of list which doesn't match for the length of columns

l = [1,7,4,1]
df.loc[range(len(l)),'sub'] = l

answered Jul 15, 2022 at 9:48

Berlin Benilo

5102 silver badges14 bronze badges

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

Comments

Hassan Rahamathullah · Accepted Answer · 2022-07-15 09:39:23Z

2

you can do like this:

import pandas as pd
df = pd.read_excel('~/Downloads/excel_name.xlsx')
array = [1,4,7,1]
df['sub'] = array
print(df)

# output
    name  sub
0  test1    1
1  test2    4
2  test3    7
3  test4    1

Warning: Your array and the number of rows in your excel should match.

Edit: Your code also should work, please check the index which you are trying to add, if the last index of the df goes beyond three then it will throw error.

edited Jul 15, 2022 at 9:39

answered Jul 15, 2022 at 9:36

Hassan Rahamathullah

414 bronze badges

2 Comments

Mehdi Aria Over a year ago

What's the solution if these two don't match?

Hassan Rahamathullah Over a year ago

you have two solution, if you want to join across proper key, then you can use pandas join and second solution is, if you want the value to be sequentially added in the dataframe, then create array with null elements on the remaining value and use the above method.

Collectives™ on Stack Overflow

Pandas adding values into the dataframe

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related