Add len of two DataFrames

Question

I have two DataFrames df1 and df2.

I want to see what the length of both is added up.

But it seems I can't do len(df1) + len(df2).

Is there a quick way to do this (without joining them)?

Why can you not? If I do it it works fine. – Yorian Oct 03 '17 at 14:42 — Yorian, Oct 03 '17 at 14:42
Hm - maybe something is off with my index - let me try – jeangelj Oct 03 '17 at 14:45 — jeangelj, Oct 03 '17 at 14:45

jezrael · Accepted Answer · 2017-10-03T14:38:03.610

2

I think the fastest is sum lengths of indexes:

len(df1.index) + len(df2.index)

But is is same like your solution:

len(df1) + len(df2)

edited Oct 03 '17 at 14:38

answered Oct 03 '17 at 14:32

jezrael

the index one works for me - I don't know why the one without index didn't' than kyou – jeangelj Oct 03 '17 at 14:45

score 1 · Answer 2 · answered Oct 03 '17 at 14:33

1

By using shape

df1.shape[0]+df2.shape[0]

answered Oct 03 '17 at 14:33

BENY

2 Answers2