DataFrame Manipulations

xxxxxxxxxx

 

1

import pandas

2

fp='https://raw.githubusercontent.com/'+\

3

   'OlgaBelitskaya/data/main/external_json/'

4

se=pandas.read_json(fp+'h7rb-945c.json')

5

fl=['dbn','ell_programs','language_classes',

6

    'finalgrades','total_students',

7

    'graduation_rate','attendance_rate',

8

    'college_career_rate','pct_stu_safe',

9

    'pct_stu_enough_variety','latitude',

10

    'longitude','council_district','city']

11

se=se[fl]

12

sesum=se.isna().sum()[se.isna().sum()!=0]

13

print(sesum.to_frame()); print('\n')

14

se=se.dropna(); se.head().loc[:2].T

Language: Sage Gap GP HTML Macaulay2 Maxima Octave Python R Singular

---

Messages