Current Expense of Education

Calculation of current expense (cost) of education per average daily attendance (ADA) pursuant to Education Code Section 41372.

cde.ca.gov-current_expense-1.2.1. Modified 2021-03-11T00:49:21

Resources | Packages | Documentation| Contacts| Data Dictionary

Resources

Documentation

Calculation of current expense (cost) of education per average daily attendance.

This dataset includes one file for each of the source files, and one file with all other files combined. The combined file maps column names, because among the source fiels, there are 4 different column headers. No other processing is done.

Contacts

Data Dictionary

current_expense_98 | current_expense_01 | current_expense_03 | current_expense_11 | combined_current_expense

current_expense_98

Column NameData TypeDescription
countyinteger
districtstring
lea_idinteger
expendituresnumber
adanumber
cost_per_adanumber
lea_typestring

current_expense_01

Column NameData TypeDescription
countyinteger
lea_idinteger
districtstring
expendituresnumber
adainteger
cost_per_adanumber
lea_typestring

current_expense_03

Column NameData TypeDescription
countyinteger
lea_idinteger
districtstring
expendituresnumber
adanumber
cost_per_adanumber
lea_typestring

current_expense_11

Column NameData TypeDescription
countyinteger
lea_idinteger
districtstring
expendituresnumber
adanumber
cost_per_adanumber
lea_typestring

combined_current_expense

Column NameData TypeDescription
yearintegerYear of the original source file
countyintegerCounty FIPS number
districtstringDistrict name
lea_idintegerDistrict code, the D part of the CDS code
expendituresnumberTotal district expenditures (EDP 365), in current dollars.
adanumberAverage Daily attendance used for the cost per ada calculation
cost_per_adanumberCost per average daily attendance
lea_typestringType of district: High school Elementary or Unified

Packages

Accessing Data in Vanilla Pandas

import pandas as pd


current_expense_98_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_98.csv')
current_expense_99_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_99.csv')
current_expense_00_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_00.csv')
current_expense_01_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_01.csv')
current_expense_02_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_02.csv')
current_expense_03_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_03.csv')
current_expense_04_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_04.csv')
current_expense_05_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_05.csv')
current_expense_06_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_06.csv')
current_expense_07_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_07.csv')
current_expense_08_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_08.csv')
current_expense_09_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_09.csv')
current_expense_10_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_10.csv')
current_expense_11_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_11.csv')
current_expense_12_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_12.csv')
current_expense_13_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_13.csv')
current_expense_14_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_14.csv')
current_expense_15_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_15.csv')
current_expense_16_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_16.csv')
current_expense_17_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_17.csv')
combined_current_expense_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/combined_current_expense.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1.csv')

# Create Dataframes
current_expense_98_df = pkg.resource('current_expense_98').dataframe()
current_expense_99_df = pkg.resource('current_expense_99').dataframe()
current_expense_00_df = pkg.resource('current_expense_00').dataframe()
current_expense_01_df = pkg.resource('current_expense_01').dataframe()
current_expense_02_df = pkg.resource('current_expense_02').dataframe()
current_expense_03_df = pkg.resource('current_expense_03').dataframe()
current_expense_04_df = pkg.resource('current_expense_04').dataframe()
current_expense_05_df = pkg.resource('current_expense_05').dataframe()
current_expense_06_df = pkg.resource('current_expense_06').dataframe()
current_expense_07_df = pkg.resource('current_expense_07').dataframe()
current_expense_08_df = pkg.resource('current_expense_08').dataframe()
current_expense_09_df = pkg.resource('current_expense_09').dataframe()
current_expense_10_df = pkg.resource('current_expense_10').dataframe()
current_expense_11_df = pkg.resource('current_expense_11').dataframe()
current_expense_12_df = pkg.resource('current_expense_12').dataframe()
current_expense_13_df = pkg.resource('current_expense_13').dataframe()
current_expense_14_df = pkg.resource('current_expense_14').dataframe()
current_expense_15_df = pkg.resource('current_expense_15').dataframe()
current_expense_16_df = pkg.resource('current_expense_16').dataframe()
current_expense_17_df = pkg.resource('current_expense_17').dataframe()
combined_current_expense_df = pkg.resource('combined_current_expense').dataframe()