Fourth try with cleaned dataset #30

	name: Run ETL when source file change

	on:
	push:
	paths:
	- etl/source/boendebarometer.ddf.xlsx

	jobs:
	run-script:
	runs-on: ubuntu-latest

	steps:
	- name: Checkout repository
	uses: actions/checkout@v4

	- name: Set up Python 3.10
	uses: actions/setup-python@v5
	with:
	python-version: "3.10"

	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install -r etl/scripts/requirements.txt

	- name: Run Python script
	run: \|
	ddf cleanup ddf .
	cd etl/scripts
	python etl.py
	cd ../../
	ddf create_datapackage --update .

	- name: Commit and push changes
	run: \|
	git config --local user.name "github-actions[bot]"
	git config --local user.email "github-actions[bot]@users.noreply.github.com"
	git add .
	git commit -m "Automated commit by GitHub Actions"
	git push
	env:
	GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}

Provide feedback