Title

---

toc: true layout: post

title: Pandas Hacks

In this notebook we will:

• Read a file containing data of baseball players
• fetch certain players' data

import pandas as pd

padres = pd.read_json('files/baseballplayers.json')

print (padres)

               Hitter                Position         Average in 2022  \
0       Trent Grisham            Center Field                    .184   
1  Fernando Tatis Jr.             Right Field  DNP (.281 Avg in 2021)   
2           Juan Soto              Left Field                    .242   
3       Manny Machado              Third Base                    .298   
4     Xander Bogaerts               Shortstop                    .307   
5    Jake Cronenworth              First Base                    .239   
6         Nelson Cruz  Designated Hitter (DH)                    .234   
7      Matt Carpenter                 Utility                    .305   
8        Ha-Seong Kim             Second Base                    .251   
9         Austin Nola                 Catcher                    .251   

            Home Runs in 2022           RBIs in 2022      Career OPS in 2022  
0                          17                     53                    .625  
1  DNP (42 home runs in 2021)  DNP (97 RBIs in 2021)  DNP (.975 OPS in 2021)  
2                          27                     62                    .853  
3                          32                    102                    .897  
4                          15                     73                    .833  
5                          17                     88                    .722  
6                          10                     64                     651  
7                          15                     37                   1.138  
8                          10                     59                    .708  
9                           4                     40                    .650  

print(padres[['Position']])

print()

print(padres[['Hitter', 'Position']].to_string(index=False))

                 Position
0            Center Field
1             Right Field
2              Left Field
3              Third Base
4               Shortstop
5              First Base
6  Designated Hitter (DH)
7                 Utility
8             Second Base
9                 Catcher

            Hitter               Position
     Trent Grisham           Center Field
Fernando Tatis Jr.            Right Field
         Juan Soto             Left Field
     Manny Machado             Third Base
   Xander Bogaerts              Shortstop
  Jake Cronenworth             First Base
       Nelson Cruz Designated Hitter (DH)
    Matt Carpenter                Utility
      Ha-Seong Kim            Second Base
       Austin Nola                Catcher