Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

some csv files are not detected correctly in file open and clipborad #277

Open
krajcsi opened this issue Dec 5, 2023 · 0 comments
Open
Labels

Comments

@krajcsi
Copy link
Contributor

krajcsi commented Dec 5, 2023

pd.read_csv(data, sep=None, engine='python') does not detect for example, https://github.com/CrumpLab/7709Rbook/blob/master/data/WHR2018.csv

other engines do not work correctly either

tested with pandas 1.5.3 and 2.1.3

consider using https://github.com/alan-turing-institute/CleverCSV instead (although at the moment, clevercsv cannot handle io.StringIO() )

but seemingly, clevercsv cannot handle single column files: #152

@krajcsi krajcsi added the bug label Dec 5, 2023
@krajcsi krajcsi changed the title tab separator is not detected automatically in csv files tab separator is not detected automatically in csv files and clipborad Dec 5, 2023
@krajcsi krajcsi changed the title tab separator is not detected automatically in csv files and clipborad some csv files are not detected correctly in file open and clipborad Jan 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant