PSA-LPSD Tools
Project description
psalpsdtools
psalpsdtools is a file maintenance Python package tool designed specifically for the Livestock and Poultry Statistics Division to streamline file management and updating processes. This comprehensive package provides a user-friendly interface and a robust set of functionalities to efficiently organize, manipulate, and validate data files. From data cleaning and merging to filtering and report generation, this package offers a reliable solution to enhance productivity and ensure only accurate information are produced. Furthermore, this package is continuously evolving with ongoing development, promising future enhancements and additional functionalities to cater to the evolving needs of the division.
Features
Some of the features include:
Electronic Data Review Worksheet (EDRW)
- Lookup and copying of values from the Supply-Disposition worksheet
- Pasting values to the EDRW output file
- Generation of output files by province, based on user specified inputs which includes:
- region
- commodity
- year
Built-in Functions
-
get_regions - returns a list of regions.
-
get_provinces - returns a list of provinces of a given region.
Requirements
Python 3.8 or later with all required dependencies installed. To install run:
pip install psalpsdtools
Usage
EDRW Updating
- Pre-requisites (for Chicken)
-
baseFolder should contain the S-D file.
-
inside baseFolder, a folder named Sources must exist, containing the regional folders and the provincial files inside.
-
Provincial EDRW source files should have .xlsm extensions
-
Currently, source filename is expected to be "cc " + province name + "_year", e.g. 08 Agusan del Norte_23.xlsm
- Example code:
from psalpsdtools import Edrw
# Specify Region
regName = 'Caraga'
# Specify quarter
# Used in identifying which worksheet to paste the copied values from the S-D file.
qtr = 'Q1'
# Specify folder location of Sources and Final files.
# The S-D file should also be found here.
baseFolder = 'D:/EDRW/Q1'
# Specify S-D filename
# IMPORTANT! Only .xlsm or .xlsx extensions are accepted
sdFile = 'SD Q1 2023.xlsm'
# Commodity code i.e. 08=chicken, 09=duck, etc.
commcode = '08'
# Year
yr = '23'
# Call an instance of the Edrw package
myedrw = Edrw()
# Run update_sources with the parameters
myedrw.update_sources(regName,qtr,baseFolder,sdFile,commcode,yr)
Built-in Functions
get_regions
Example code:
from psalpsdtools import PhRegPrv
philippines = PhRegPrv()
regions = philippines.get_regions()
for region in regions:
print(region)
get_provinces
Example code:
from psalpsdtools import PhRegPrv
# Specifiy a region
regname = 'Caraga'
philippines = PhRegPrv()
provinces = philippines.get_provinces(regname)
for province in provinces:
print(province)
Contribute
Issue Tracker: github.com/tondiaz/psalpsdtools/issues
Source Code: github.com/tondiaz/psalpsdtools
License
The project is licensed under the MIT license.
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.