datagouv / csv-detective

CSV inspection
45 stars 10 forks source link

FutureWarning when analysing CSV #42

Closed abulte closed 1 year ago

abulte commented 1 year ago

When calling routine on https://static.data.gouv.fr/resources/adresses-au-format-bal-lacarre/20200319-151130/20200319 -bal-216402974.csv

/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
/Users/alexandre/Developer/Etalab/udata-hydra/.venv/lib/python3.9/site-packages/csv_detective/utils.py:64: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.
  return_table.loc[key] = table.apply(lambda serie: test_col_val(
abulte commented 1 year ago
$ poetry run pip freeze|grep pandas
pandas==1.5.2