PHL Budget Data
Project description
phl-budget-data
Aggregating and cleaning City of Philadelphia budget-related data
Installation
You can use the pip
command:
pip install phl_budget_data
Examples
The subsections below list examples for loading various kinds of budget-related data sets for the City of Philadelphia.
Revenue Reports
Data is available from the City of Philadelphia's Revenue reports, as published to the City's website.
City Collections
Monthly PDF reports are available on the City of Philadelphia's website according to fiscal year (example: FY 2021).
Load the data:
from phl_budget_data.clean import load_city_collections
data = load_city_collections()
data.head()
Output:
name fiscal_year total month_name month fiscal_month year date kind
0 sales 2021 14228731.0 jan 1 7 2021 2021-01-01 Tax
1 wage_earnings_net_profits 2021 182689530.0 jan 1 7 2021 2021-01-01 Tax
2 soda 2021 5149478.0 jan 1 7 2021 2021-01-01 Tax
3 outdoor_ads 2021 179166.0 jan 1 7 2021 2021-01-01 Tax
4 real_estate_transfer 2021 27222198.0 jan 1 7 2021 2021-01-01 Tax
School District Collections
Monthly PDF reports are available on the City of Philadelphia's website according to fiscal year (example: FY 2021).
Load the data:
from phl_budget_data.clean import load_school_collections
data = load_school_collections()
data.head()
Output:
name fiscal_year total month_name month fiscal_month year date
0 real_estate 2021 50817991 jan 1 7 2021 2021-01-01
1 school_income 2021 436599 jan 1 7 2021 2021-01-01
2 use_and_occupancy 2021 19395530 jan 1 7 2021 2021-01-01
3 liquor 2021 1874302 jan 1 7 2021 2021-01-01
4 other_nontax 2021 2000 jan 1 7 2021 2021-01-01
Monthly Wage Tax Collections by Industry
Monthly PDF reports are available on the City of Philadelphia's website according to calendar year (example: 2020).
Load the data:
from phl_budget_data.clean import load_wage_collections_by_sector
data = load_wage_collections_by_sector()
data.head()
Output:
industry parent_industry total month_name month fiscal_month year fiscal_year date
0 Other Governments Government 177693.0 dec 12 6 2020 2021 2020-12-01
1 Social Services Health and Social Services 4631670.0 dec 12 6 2020 2021 2020-12-01
2 Outpatient Care Centers and Other Health Services Health and Social Services 5302884.0 dec 12 6 2020 2021 2020-12-01
3 Doctors, Dentists, and Other Health Practitioners Health and Social Services 3390537.0 dec 12 6 2020 2021 2020-12-01
4 Hospitals Health and Social Services 19327622.0 dec 12 6 2020 2021 2020-12-01
Quarterly City Manager's Report
PDF reports are available on the City of Philadelphia's website here.
Coming Soon
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for phl_budget_data-0.1.6-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f6c6b4fdb4d563728f60b192fd7590b756a821e8c44e5b7f72430643dde79028 |
|
MD5 | 42f37acb906c2491bcbe4eae11c90938 |
|
BLAKE2b-256 | b1d79f21a436b29220d92bebfdc59296c4590475c3e047e9bf1a393aa57bd6f1 |