ericemc3

Results 43 comments of ericemc3

Hi @Tmonster, thank you for taking this into account. Here is an updated test case: ``` CREATE OR REPLACE TABLE t AS SELECT code_insee, geometry FROM 'https://static.data.gouv.fr/resources/ban-format-parquet/20231228-103716/adresses-france-2023.parquet' WHERE quadkey IN...

Indeed it looks fixed in last dev version, thanks!

What about: ``` df % mutate(a = coalesce(!!!select(., -id))) # A tibble: 5 x 6 id w x y z a 1 1 10 NA NA NA 10 2 2...

> utiliser snappy comme format de compression qui correspond au format de compression par défaut en R. > Pour les variables de type date (ex : date de naissance, date...

En effet, je trouve pour ma part `openxlsx `intéressant en _écriture_ de fichiers xlsx, `openxlsx ::write.xlsx` présente de multiples options bien pratiques pour personnaliser ses exports.

Hi, 👍 any update or explanation for this issue?

> FWIW I just migrated to use read_xlsx() as of duckdb1.2 This isn't about Excel, but rather GTFS or GIS formats in general, for which st_read is essential...

Hello, sorry for that, previous URL is now returning an html error... Here is a more stable one `FROM read_json('https://geomsa.msa.fr/GC_indic.php?indic=pop_insee&dataset=pop_insee&view=map6&lang=fr') ;`

Thanks a lot for your time on this. Looking at your experiment, I think it is because the response is gzip encoded. Actually: `from read_json('https://geomsa.msa.fr/GC_indic.php?indic=pop_insee&dataset=pop_insee&view=map6&lang=fr', COMPRESSION='gzip') ;` works fine! And...

Thank you for the tip! And for looking after this, i appreciate