Question

How to select and print specific column in pandas DataFrame with Python

Answer 1

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

print(cl)

print('\n',type(cl),sep='')


  
  
'''
run:
  
0     80
1     95
2     81
3    100
4     85
Name: python, dtype: int64

<class 'pandas.core.series.Series'>

'''

 

70+ SQL courses for beginners and professionals

Answer 2

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

print(cl)

print('\n',type(cl),sep='')


  
  
'''
run:
  
0    94
1    96
2    87
3    98
4    90
Name: java, dtype: int64

<class 'pandas.core.series.Series'>

'''

 

70+ SQL courses for beginners and professionals