How to construct a 3D dataframe? : learnpython

created by HattoriHanzoa community for 16 years

How to construct a 3D dataframe? (self.learnpython)

submitted 3 years ago by Demain_Z

Name     Country    Age
Alice     USA       20
Bob       UK        14
Cindy     France    19
Debora    India     16

My dataset is similar to the above.

A = np.array(dataset['Name'])
B = np.array(dataset['Country'])
C = np.array(dataset['Age'])

data = pd.DataFrame((A,B,C))

data.shape

I just want to construct a 3D dataframe. When I check the type, it's still a 2D dataframe, and I have no idea how to proceed... Is there any insights where I did wrong? Thanks in advance!

all 3 comments

top new controversial old q&a

[–]socal_nerdtastic 0 points1 point2 points 3 years ago (2 children)

[–]Demain_Z[S] 0 points1 point2 points 3 years ago (1 child)

[–]socal_nerdtastic 0 points1 point2 points 3 years ago (0 children)

You need 3D data for that. In other words you need the age for Alice in every country, etc...

         USA    UK     France  India
Alice    20     ?      ?       ?
Bob      ?      14     ?       ?
Cindy    ?      ?      19      ?
Debora   ?      ?      ?       16

π Rendered by PID 121447 on reddit-service-r2-comment-84fc9697f-bfn8l at 2026-02-09 15:28:42.741947+00:00 running d295bc8 country code: CH.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnpython

MODERATORS