create a dataframe with dataframes of different sizes

Question

I have a dataframe and two array with differents sizes and i want to create a single dataframe

for example

import pandas
import numpy

 df = pandas.DataFrame(numpy.array([[0,0,1]]),columns = ['A', 'B', 'C'])
  V1=numpy.array([0,1,3,4])
  V2=numpy.array([2,3,5,8,11,12])

I want obtain a single dataframe like :

  A  B  C V1 V2
  0  0  1 0   2
  0  0  1 1   3
  0  0  1 3   5
  0  0  1 4   8   
  0  0  1 Nan 11
  0  0  1 Nan 12

stackoverflow.com/questions/18646076/…: Chk this

Rahul Agarwal
– Rahul Agarwal

2019-04-02 13:23:15 +00:00
Commented Apr 2, 2019 at 13:23 — Rahul Agarwal
– Rahul Agarwal, Commented Apr 2, 2019 at 13:23

jezrael · Accepted Answer · 2019-04-02 13:34:11Z

1

First is necessary repeat array in first DataFrame by maximum length of array, then create for each array Series and join together by concat:

a = [V1, V2]
n = max(map(len, a))
df1 = pd.DataFrame(np.array(np.repeat([[0,0,1]], n, axis=0)), columns = ['A', 'B', 'C'])
df = pd.concat([df1, pd.Series(V1, name='V1'), pd.Series(V2, name='V2')], axis=1)
print (df)
   A  B  C   V1  V2
0  0  0  1  0.0   2
1  0  0  1  1.0   3
2  0  0  1  3.0   5
3  0  0  1  4.0   8
4  0  0  1  NaN  11
5  0  0  1  NaN  12

edited Apr 2, 2019 at 13:34

answered Apr 2, 2019 at 13:29

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

create a dataframe with dataframes of different sizes

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related