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-2

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

Packages

Accessing Packages in Metapack

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

# 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()

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

Last Modified 2019-07-23T05:40:45

Packages

Accessing Packages in Metapack

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

# 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()