Setting Python Variable from read_excel in Pandas

Question

I feel this is such a simple thing, however, I am hopelessly stuck. I have an excel df that I want to loop through and take values from to create an object.

cols = ['Net Transaction Amount', 'Original Value Transacted', 'First Name', 'Last 
Name', 'Email', 'Transaction Date', 'Card Number', 'Card Expiration Date', 
'Transaction Custom String1', 'Stripe ID', 'Payment Method', 'Total To-Date Gift 
Amount', 'Start Date', 'Next Payment Date',]
bb_cus = pd.read_excel(loc,usecols=cols, header=0)

#for i in bb_cus:
#name = bb_cus['First Name'] +' '+ bb_cus['Last Name']

#print(name)
print(bb_cus)

Here is output:

     Net Transaction Amount  ...   Next Payment Date
0                         5  ... 2020-12-12 04:05:00
1                        50  ... 2020-12-12 04:32:00
2                        10  ... 2020-12-12 07:13:00
3                        10  ... 2020-12-12 06:47:00
4                         5  ... 2020-12-12 08:26:00
...                     ...  ...                 ...
3593                     10  ... 2020-12-01 13:48:00
3594                     10  ... 2020-12-09 14:45:00
3595                     10  ... 2020-11-14 11:29:00
3596                    100  ... 2020-11-27 23:07:00
3597                  Total  ...                 NaT

[3598 rows x 14 columns]

I would like to be able to use a loop to take values from each row to create a new customer object in my DB. Something like this:

for i in bb_cus:
name = bb_cus['First Name']

print(name)

from here I get this. But I do not understand how to just get the name:

for i in bb_cus:
    name = bb_cus['First Name']

    print(name)


    3597        NaN
    Name: First Name, Length: 3598, dtype: object
    0        Dianne
    1          Jeff
    2       Shawnna
    3         Roman
    4          Geri
     ...
    3593    Richard
    3594    Dezerae
    3595      Amiya
    3596    Michael
    3597        NaN

How do I get just the name as a string rather than a new data object

How Flask is involved here?

balderman
– balderman

2020-12-07 12:21:50 +00:00
Commented Dec 7, 2020 at 12:21 — balderman
– balderman, Commented Dec 7, 2020 at 12:21

Luca Angioloni · Accepted Answer · 2020-12-07 13:49:23Z

1

In Pandas you iterate on rows with the .iterrows() method:

for i, row in bb_cus.iterrows():
    name = row['First Name']
    print(name)

edited Dec 7, 2020 at 13:49

answered Dec 7, 2020 at 12:16

Luca Angioloni

2,2532 gold badges21 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Setting Python Variable from read_excel in Pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related