Create a dataframe from arrays python

Question

I'm try to construct a dataframe (I'm using Pandas library) from some arrays and one matrix.

in particular, if I have two array like this:

A=[A,B,C]
B=[D,E,F]

And one matrix like this :

1 2 2
3 3 3
4 4 4

Can i create a dataset like this?

Maybe is a stupid question, but i m very new with Python and Pandas.

I seen this :

https://pandas.pydata.org/pandas-docs/version/0.23.4/generated/pandas.DataFrame.html

but specify only 'colums'.

I should read the matrix row for row and paste in my dataset, but I m think that exist a more easy solution with Pandas.

gorjan · Accepted Answer · 2018-12-28 17:13:22Z

26

This should do the trick for you.

columns = ["A", "B", "C"]
rows = ["D", "E", "F"]
data = np.array([[1, 2, 2], [3, 3, 3],[4, 4, 4]])
df = pd.DataFrame(data=data, index=rows, columns=columns)

edited Dec 28, 2018 at 17:13

answered Dec 28, 2018 at 17:07

gorjan

5,6452 gold badges24 silver badges44 bronze badges

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

Comments

xudesheng · Accepted Answer · 2018-12-28 17:11:05Z

4

is this what you need?

import pandas as pd
A=['A','B','C']
B=['D','E','F']
C=[[1,2,2],[3,3,3],[4,4,4]]

df=pd.DataFrame(C, columns=A)
df.index=B
df.head()

    A   B   C
D   1   2   2
E   3   3   3
F   4   4   4

answered Dec 28, 2018 at 17:11

xudesheng

1,10212 silver badges26 bronze badges

Comments

Rodwan Bakkar · Accepted Answer · 2018-12-28 17:08:34Z

3

You can do like this:

a=[[1, 2, 2],[1, 2, 2],[1, 2, 2]]
df=pd.DataFrame(a)
df.columns = ['a', 'b', 'c']
df.index = ['d', 'e', 'f']
print(df)

answered Dec 28, 2018 at 17:08

Rodwan Bakkar

4844 silver badges18 bronze badges

Collectives™ on Stack Overflow

Create a dataframe from arrays python

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related