Pandas Plotting

xxxxxxxxxx

 

1

import pandas,pylab

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].dropna()

12

f,ax=pylab.subplots(ncols=2,figsize=(6,4))

13

for i in range(2):

14

    se[fl[i+5]]=se[fl[i+5]].astype('str')\

15

    .str.replace('N/A','0').astype('float')

16

    se.plot(kind='scatter',

17

            x='longitude',y='latitude',

18

            s=10,c=fl[i+5],

19

            cmap=pylab.cm.jet,

20

            title=fl[i+5].replace('_',' '),

21

    ax=ax[i],alpha=.8,grid=True)

22

    ax[i].set_facecolor('slategray')

23

pylab.show()

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

---

Messages