Pandas, print variable in string

Question

I have a dataframe (new) that looks something like this:

num  name1  name2
11    A      AB
14    Y      YX
25    L      LS
39    Z      ZT
....

and I just want to extract the num value in a print statement such that I have an output that looks like this:

The value is 11
The value is 14
The value is 25
...

I'm not sure what the correct format to do this is, as the following bit of code just iterates "The value is".

 for index, row in new.iterrows():
     print('The value is').format(new['num'])

piRSquared · Accepted Answer · 2018-05-07 19:56:34Z

5

Use str.join and f-strings

print('\n'.join(f'The value is {n}' for n in new.num))

The value is 11
The value is 14
The value is 25
The value is 39

A slight variant and more to show how to use the print function...

print(*(f'The value is {n}' for n in new.num), sep='\n')

The value is 11
The value is 14
The value is 25
The value is 39

edited May 7, 2018 at 19:56

answered May 7, 2018 at 19:51

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

2 Comments

cs95 Over a year ago

Introducing python3.5+ features in my experience never seems to work well with OPs... stackoverflow.com/q/50194179/4909087

piRSquared Over a year ago

Yeah... well... at least non-OPs are free to appreciate it (-:

Trenton McKinney · Accepted Answer · 2021-02-22 08:23:58Z

4

Slightly change your code

for index, row in df.iterrows():
    print('The value is {0}'.format(row['num']))
    
The value is 11
The value is 14
The value is 25
The value is 39

With f-strings:

for index, row in df.iterrows():
    print(f"The value is {row['num']}")

To print multiple columns, using dot notation:

for index, row in df.iterrows():
    print(f"{row.name1} and {row.name2} have a value of {row.num}")

A and AB have a value of 11
Y and YX have a value of 14
L and LS have a value of 25
Z and ZT have a value of 39

edited Feb 22, 2021 at 8:23

Trenton McKinney

63.2k41 gold badges169 silver badges212 bronze badges

answered May 7, 2018 at 19:52

BENY

324k22 gold badges176 silver badges250 bronze badges

Comments

Alex Olteanu · Accepted Answer · 2018-05-07 20:04:18Z

3

You can loop directly through a Series object (unlike through a DataFrame object). This allows you to do:

for num in new['num']:
    print('The value is ' + str(num))

answered May 7, 2018 at 20:04

Alex Olteanu

4,3084 gold badges19 silver badges26 bronze badges

Comments

niraj · Accepted Answer · 2018-05-07 20:16:13Z

2

You can also try following:

for val in new.num: print('This is ', val)

Result:

This is  11
This is  14
This is  25
This is  39

answered May 7, 2018 at 20:16

niraj

18.2k4 gold badges36 silver badges50 bronze badges

Collectives™ on Stack Overflow

Pandas, print variable in string

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related