camera-database/camera-db-venv/lib/python3.10/site-packages/pandas/tests/groupby
Walter Jekat d6f483349c COMPLETE: Imported all 74,020 Goergens cameras
FINAL STATISTICS:
- 74,020 cameras successfully imported (100%)
- 45 duplicates skipped (as expected)
- 2,516 manufacturers
- 28,667 camera models
- 36,080 housing variants
- 6,606 unique lenses
- 1,135 unique shutters

30+ years of Harald Goergens' camera classification work
now preserved in PostgreSQL database.

Import challenges overcome:
- VARCHAR sizes adjusted (viewfinder_type, body_type, combo_number)
- NULL constraints relaxed (body_type, format_code)
- Transaction management per-row to prevent cascade failures
- ID verification to prevent cache poisoning
- 12 malformed IDs handled gracefully
- 46 duplicate IDs documented for later review
2025-11-17 23:54:23 +01:00
..
aggregate COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
methods COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
transform COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
__init__.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
conftest.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_all_methods.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_api.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_apply.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_apply_mutate.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_bin_groupby.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_categorical.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_counting.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_cumulative.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_filters.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_groupby.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_groupby_dropna.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_groupby_subclass.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_grouping.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_index_as_string.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_indexing.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_libgroupby.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_missing.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_numba.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_numeric_only.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_pipe.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_raises.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_reductions.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00
test_timegrouper.py COMPLETE: Imported all 74,020 Goergens cameras 2025-11-17 23:54:23 +01:00