Question

How to convert pandas DataFrame to numpy array in Python

Answer 1

import pandas as pd
  
df = pd.DataFrame(
    [['Tom', 91, 80, 94],
     ['Emmy', 98, 95, 96],
     ['Rubeus', 87, 81, 87],
     ['Voldemort', 82, 86, 91],
     ['Dumbledore', 99, 100, 98],
     ['Axel', 75, 85, 90]],
    columns=['name', 'algebra', 'python', 'java'])

arr = df.to_numpy()

print(arr)

   
   
'''
run:
   
[['Tom' 91 80 94]
 ['Emmy' 98 95 96]
 ['Rubeus' 87 81 87]
 ['Voldemort' 82 86 91]
 ['Dumbledore' 99 100 98]
 ['Axel' 75 85 90]]

'''

 

70+ SQL courses for beginners and professionals

Answer 2

import pandas as pd
  
df = pd.DataFrame(
    [['Tom', 91, 80, 94.5],
     ['Emmy', 98, 95, 96],
     ['Rubeus', 87, 81, 87],
     ['Voldemort', 82, 86, 91],
     ['Dumbledore', 99, 100, 98],
     ['Axel', 75, 85, 90]],
    columns=['name', 'algebra', 'python', 'java'])

arr = df.to_numpy()

print(df.dtypes, '\n')

print(arr, '\n')
print(arr.dtype)


   
   
'''
run:
   
name        object
algebra      int64
python       int64
java       float64
dtype: object 

[['Tom' 91 80 94.5]
 ['Emmy' 98 95 96.0]
 ['Rubeus' 87 81 87.0]
 ['Voldemort' 82 86 91.0]
 ['Dumbledore' 99 100 98.0]
 ['Axel' 75 85 90.0]] 

object

'''

 

70+ SQL courses for beginners and professionals

Answer 3

import pandas as pd
  
df = pd.DataFrame(
    [[91, 80, 94.5],
     [98, 95, 96],
     [87, 81, 87],
     [82, 86, 91],
     [99, 100, 98],
     [75, 85, 90]],
    columns=['algebra', 'python', 'java'])

arr = df.to_numpy()

print(df.dtypes, '\n')

print(arr, '\n')
print(arr.dtype)


   
   
'''
run:
   
algebra      int64
python       int64
java       float64
dtype: object 

[[ 91.   80.   94.5]
 [ 98.   95.   96. ]
 [ 87.   81.   87. ]
 [ 82.   86.   91. ]
 [ 99.  100.   98. ]
 [ 75.   85.   90. ]] 

float64

'''

 

70+ SQL courses for beginners and professionals