Python: Add Count of Rows from df to Another df as New Column

Question

Let's say I counted the number of rows in a pandas dataframe. I use the following code to do that:

df.shape

It gives me the following result: (1700, 12)

How do I add the 1700 value to an existing pandas dataframe? We'll call the column associated with that value D.

Current dataframe:

A    B   C
30   40  text

Desired dataframe:

A    B   C       D
30   40  text    1700

Possible duplicate of [Set value to an entire column of a pandas dataframe](https://stackoverflow.com/questions/44723183/set-value-to-an-entire-column-of-a-pandas-dataframe) — Ami Tavory, Apr 17 '18 at 20:40

score 0 · Answer 1 · answered Apr 17 '18 at 22:01

0

you store your shape in a variable of type tuple and then you create a new column and paste the first value of the tuple

tab = df.shape

df['D'] = tab[0]

answered Apr 17 '18 at 22:01

youssef mhiri

1 Answers1