Create an Array from a Dataframe Row

Question

I need to make 2 arrays from a dataframe.

The first one is just an array of the column headers: np.array(df.columns) The second array would be all values from these columns (dataframe only has 1 row).

However I get this output:

array([array(66.84119159), array(67.38531331), array(67.74187959),
       array(68.00048307), array(68.22388778), array(68.39191308),
       array(68.51329445), array(68.62896006), array(68.716791),
       array(68.77379008), array(68.81400731), array(68.83634255),
       array(68.84203308), array(68.82682576), array(68.79121712),
       array(68.74733508), array(68.68588568), array(68.58466205),
       array(68.46882076), array(68.31954362), array(68.16374208),
       array(67.97388601), array(67.79819623), array(67.65393439),
       array(67.50348453), array(67.34438603), array(67.19034766),
       array(67.11430317), array(66.63700965), array(65.39818456),
       array(63.90516399)], dtype=object)

Is there a way to create an array having only one "array" and not a packaged array?

thanks

check this link stackoverflow.com/questions/13187778/… or this link stackoverflow.com/questions/33907776/… — Daniyal Sedighpour
– Daniyal Sedighpour, Commented Jun 21, 2021 at 9:04

Andreas · Accepted Answer · 2021-06-21 09:06:34Z

0

You can use the dataframe values:

import pandas as pd
df = pd.DataFrame({'test': range(10)}).T

df.values

Out[13]: array([[0, 1, 2, 3, 4, 5, 6, 7, 8, 9]], dtype=int64)

answered Jun 21, 2021 at 9:06

Andreas

9,2853 gold badges20 silver badges47 bronze badges

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

2 Comments

Ben Over a year ago

thanks for the reply. I still get this packaged version with 1 number = 1 array

Andreas Over a year ago

@Ben yes but you could do something like this: df.values[0] is there a reason not to?

Collectives™ on Stack Overflow

Create an Array from a Dataframe Row

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related