Forum
Aktif konular
Üyeler
Kurallar
Arama
Python Kodu Fix Python Kodu Fix
-
Arkadaslar merhaba,
daha onceden @iKlotho benim icin buradaki (https://github.com/iKlotho/statereports) kodu yazmisti fakat artik calismiyor. Kendisine duzeltme icin ulasamiyorum.
Bu python kodu araciligi ile kaynaktan excel dosyasina datayi cekebiliyordum. Fakat artik calismiyor. Kaynak linkleri degistigi icin calismadigini dusunuyorum fakat linkleri kodun icerisinde duzeltince yine calismiyor. Tekrar calisir duruma getirmeme yardimci olabilecek var mi?
-
https://pastebin.pl/view/3d9640bd
py test.py -y 2023 # her eyalet ayrı sheet, XLSX
py test.py -y 2023 -s f # hepsi tek sheet, XLSX
py test.py -y 2023 -t csv # hepsi tek dosya, CSV
--------- kurulacak kutuphaneler
python -m pip install --upgrade pip
python -m pip install selenium
python -m pip install webdriver-manager
python -m pip install requests
python -m pip install beautifulsoup4
python -m pip install pandas
python -m pip install lxml
python -m pip install html5lib
python -m pip install XlsxWriter
işine yararmı bilmiyorum denersin -
hocam tek yapacagin, statereport folderindeki state_report.py dosyasini editlemek. 12. satir. aha burasi yani: https://github.com/iKlotho/statereports/blob/master/statereport/state_report.py#L12
bunu degistirip:
self.raw_data_url= f"https://www.ic3.gov/media/annualreport/{year}State/stats?s="
boyle yap:self.raw_data_url= f"https://www.ic3.gov/AnnualReport/Reports/{year}State/stats?s="
"fakat linkleri kodun icerisinde duzeltince yine calismiyor." demissin ama bana gayette calisiyor :D
garga tarafından 22/Nis/25 14:09 tarihinde düzenlenmiştir
-
garga adamdır
-
ayd bunu yazdı
garga adamdır
Kankam sagolasin o senin adamlığın :)
-
garga bunu yazdı
hocam tek yapacagin, statereport folderindeki state_report.py dosyasini editlemek. 12. satir. aha burasi yani: https://github.com/iKlotho/statereports/blob/master/statereport/state_report.py#L12
bunu degistirip:
self.raw_data_url= f"https://www.ic3.gov/media/annualreport/{year}State/stats?s="
boyle yap:self.raw_data_url= f"https://www.ic3.gov/AnnualReport/Reports/{year}State/stats?s="
"fakat linkleri kodun icerisinde duzeltince yine calismiyor." demissin ama bana gayette calisiyor :D
Oncelikle
git clone https://github.com/iKlotho/statereports
bu kod ile clonlama yapiyorum. Daha sonra indirilen klasore girip statereport folderindeki state_report.py dosyasinda 12. satiri editliyorum.
sonra terminalden ilgili klasore geliyorum.
cd statereports
hemen sonrasinda asagidaki kodu yaziyorum fakat ekteki hatayi aliyorum.
pip3 install -r requirements.txt
192:statereports username$ pip3 install -r requirements.txt Collecting XlsxWriter==1.1.8 (from -r requirements.txt (line 1)) Using cached XlsxWriter-1.1.8-py2.py3-none-any.whl.metadata (2.4 kB) Collecting pandas==0.24.2 (from -r requirements.txt (line 2)) Using cached pandas-0.24.2.tar.gz (11.8 MB) Installing build dependencies ... done Getting requirements to build wheel ... error error: subprocess-exited-with-error × Getting requirements to build wheel did not run successfully. │ exit code: 1 ╰─> [34 lines of output] <string>:12: DeprecationWarning: pkg_resources is deprecated as an API. See https://setuptools.pypa.io/en/latest/pkg_resources.html <string>:435: DeprecationWarning: distutils Version classes are deprecated. Use packaging.version instead. <string>:436: DeprecationWarning: distutils Version classes are deprecated. Use packaging.version instead. Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/3.13/lib/python3.13/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 389, in <module> main() ~~~~^^ File "/Library/Frameworks/Python.framework/Versions/3.13/lib/python3.13/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 373, in main json_out["return_val"] = hook(**hook_input["kwargs"]) ~~~~^^^^^^^^^^^^^^^^^^^^^^^^ File "/Library/Frameworks/Python.framework/Versions/3.13/lib/python3.13/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 143, in get_requires_for_build_wheel return hook(config_settings) File "/private/var/folders/qq/g4pxdv3d58x3nb0tn30qs6kw0000gn/T/pip-build-env-wdskihkg/overlay/lib/python3.13/site-packages/setuptools/build_meta.py", line 331, in get_requires_for_build_wheel return self._get_build_requires(config_settings, requirements=[]) ~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/private/var/folders/qq/g4pxdv3d58x3nb0tn30qs6kw0000gn/T/pip-build-env-wdskihkg/overlay/lib/python3.13/site-packages/setuptools/build_meta.py", line 301, in _get_build_requires self.run_setup() ~~~~~~~~~~~~~~^^ File "/private/var/folders/qq/g4pxdv3d58x3nb0tn30qs6kw0000gn/T/pip-build-env-wdskihkg/overlay/lib/python3.13/site-packages/setuptools/build_meta.py", line 512, in run_setup super().run_setup(setup_script=setup_script) ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/private/var/folders/qq/g4pxdv3d58x3nb0tn30qs6kw0000gn/T/pip-build-env-wdskihkg/overlay/lib/python3.13/site-packages/setuptools/build_meta.py", line 317, in run_setup exec(code, locals()) ~~~~^^^^^^^^^^^^^^^^ File "<string>", line 732, in <module> File "/private/var/folders/qq/g4pxdv3d58x3nb0tn30qs6kw0000gn/T/pip-install-zue0v8_i/pandas_cfcd7816349849cdba2c562f8c89862d/versioneer.py", line 1409, in get_version return get_versions()["version"] ~~~~~~~~~~~~^^ File "/private/var/folders/qq/g4pxdv3d58x3nb0tn30qs6kw0000gn/T/pip-install-zue0v8_i/pandas_cfcd7816349849cdba2c562f8c89862d/versioneer.py", line 1343, in get_versions cfg = get_config_from_root(root) File "/private/var/folders/qq/g4pxdv3d58x3nb0tn30qs6kw0000gn/T/pip-install-zue0v8_i/pandas_cfcd7816349849cdba2c562f8c89862d/versioneer.py", line 399, in get_config_from_root parser = configparser.SafeConfigParser() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ AttributeError: module 'configparser' has no attribute 'SafeConfigParser'. Did you mean: 'RawConfigParser'? [end of output] note: This error originates from a subprocess, and is likely not a problem with pip. error: subprocess-exited-with-error × Getting requirements to build wheel did not run successfully. │ exit code: 1 ╰─> See above for output. note: This error originates from a subprocess, and is likely not a problem with pip.Sonra calisma ihtimaline karsi asagidaki kodu yazinca yine ekteki hayati aliyorum.
python3 fetch_and_save.py -y 2021
Progress: |██████████████████████████████████████████████████████---| 94.7% CompProgress: |███████████████████████████████████████████████████████--| 96.5% CompProgress: |████████████████████████████████████████████████████████-| 98.2% CompProgress: |█████████████████████████████████████████████████████████| 100.0% Complete Progress: |██████████████████████████████████████████████████████████| 101.8% CoFinished parsing... You can access raw data with final_data or Extract using extract Extracting file... [sheeted=True|to=xlsx] Traceback (most recent call last): File "/Users/username/statereports/fetch_and_save.py", line 22, in sp.extract(sheeted=args.sheeted, to=args.to) ~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/username/statereports/statereport/state_report.py", line 67, in extract writer.save() ^^^^^^^^^^^ AttributeError: 'XlsxWriter' object has no attribute 'save'
matr0x tarafından 22/Nis/25 16:17 tarihinde düzenlenmiştir -
kodu denemedim ama save fonksiyonu bulamıyormuş
hatayı araştırdığım ilgili classın save fonksiyonunu kaldırmışlar
writer.close() kullanın demişler stackoverflow da
wert tarafından 22/Nis/25 16:18 tarihinde düzenlenmiştir -
Ben githubdan zip indirip direk Ubuntu serverde test ettim. 12. satırı degistim çalıştı. Başka hicbirsey yapmadim.
Mobildeyim su an yolladığın hatalara bakamiyore...
-
garga bunu yazdı
Ben githubdan zip indirip direk Ubuntu serverde test ettim. 12. satırı degistim çalıştı. Başka hicbirsey yapmadim.
Mobildeyim su an yolladığın hatalara bakamiyore...
Anladim hocam. Musaitte hatalara bakip goru donus yaparsan cok memnun olurum. Tesekkurler.
-
https://manus.im/ başarılı. buna düzelttir hocam öyle dene.
-
Anasını belledi forumun ;)garga tarafından 22/Nis/25 23:17 tarihinde düzenlenmiştir
Kısayol
Şikayet
Özel Mesaj
Alıntı yap
Cevapla