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.2. Modified 2022-08-09T16:57:45

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.

License

The source data, from the California Department of Education, does not explicitly reference a license, but since the top-level website for California indicates that data published on the State of California website is generally in the public domain, we assume it is in the public domain. Derived data included in this package is also in the public domain. Metadata in this package ( contained in the metadata.csv file ) is derived from metadata for the source package, and is also in the public domain.

Programs used for data transformation (contained in the notebooks directory), are Copyright 2021 Civic Knowledge, and are relased under the Creative Commons Attribution-ShareAlike 4.0 International License.

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://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_98.csv')
current_expense_99_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_99.csv')
current_expense_00_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_00.csv')
current_expense_01_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_01.csv')
current_expense_02_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_02.csv')
current_expense_03_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_03.csv')
current_expense_04_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_04.csv')
current_expense_05_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_05.csv')
current_expense_06_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_06.csv')
current_expense_07_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_07.csv')
current_expense_08_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_08.csv')
current_expense_09_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_09.csv')
current_expense_10_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_10.csv')
current_expense_11_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_11.csv')
current_expense_12_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_12.csv')
current_expense_13_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_13.csv')
current_expense_14_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_14.csv')
current_expense_15_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_15.csv')
current_expense_16_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_16.csv')
current_expense_17_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_17.csv')
current_expense_18_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_18.csv')
current_expense_19_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_19.csv')
current_expense_20_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_20.csv')
combined_current_expense_df =  pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/combined_current_expense.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2.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()
current_expense_18_df = pkg.resource('current_expense_18').dataframe()
current_expense_19_df = pkg.resource('current_expense_19').dataframe()
current_expense_20_df = pkg.resource('current_expense_20').dataframe()
combined_current_expense_df = pkg.resource('combined_current_expense').dataframe()