Python Forum
How to transform array into dataframe or table?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to transform array into dataframe or table?
#1
I would like to transform the array below into a dataframe with two columns. The values on the right will be column 1 and the values on the left will be column 2.

[[ 0 219]
[ 1 330977]
[ 2 1621]
[ 3 480]
[ 4 1560902]
[ 5 130]
[ 6 295]
[ 8 0]
[ 9 8683]
[ 10 0]
[ 14 8050]
[ 16 0]]

Thank you.
Reply
#2
s = """
[[ 0 219]
[ 1 330977]
[ 2 1621]
[ 3 480]
[ 4 1560902]
[ 5 130]
[ 6 295]
[ 8 0]
[ 9 8683]
[ 10 0]
[ 14 8050]
[ 16 0]]
"""

import numpy as np
data = np.mat(s).reshape(2, int(np.prod(np.mat(s).shape) / 2)).T
# Also, you can turn it into Data Frame:
import pandas as pd
df = pd.DataFrame(data)
Reply
#3
(Mar-29-2019, 03:50 AM)scidam Wrote: s = """
[[ 0 219]
[ 1 330977]
[ 2 1621]
[ 3 480]
[ 4 1560902]
[ 5 130]
[ 6 295]
[ 8 0]
[ 9 8683]
[ 10 0]
[ 14 8050]
[ 16 0]]
"""

import numpy as np
data = np.mat(s).reshape(2, int(np.prod(np.mat(s).shape) / 2)).T
# Also, you can turn it into Data Frame:
import pandas as pd
df = pd.DataFrame(data)

Thats great! thanks a lot!
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Transform a list standenman 3 391 Feb-20-2024, 07:52 PM
Last Post: Thadectives
  How to get array fit/transform to be correct? Oliver 0 1,512 Jul-01-2021, 04:22 PM
Last Post: Oliver
  Dataframe with array value Tibovdv 2 2,401 Mar-24-2021, 07:22 PM
Last Post: Tibovdv
  transform result to DataFrame Irv1n 1 2,044 Jan-29-2021, 10:08 PM
Last Post: Irv1n
  Creating look up table/matrix from 3d data array chai0404 3 2,824 Apr-09-2020, 04:53 AM
Last Post: buran
  converting dataframe to int numpy array glennford49 1 2,290 Apr-04-2020, 06:15 AM
Last Post: snippsat
  Transform Facebook Graph API insights JSON to pandas dataframe usman 0 1,932 Mar-03-2020, 05:14 AM
Last Post: usman
  pandas Dataframe as "confidence table" for matchmaking? takaa 1 3,403 Nov-28-2017, 07:48 PM
Last Post: takaa
  Fast Fourier Transform muhsin 1 3,099 Oct-13-2017, 07:50 PM
Last Post: nilamo
  access a very large file? As an array or as a dataframe? Angelika 5 4,857 May-18-2017, 08:15 AM
Last Post: Angelika

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020