Warm tip: This article is reproduced from serverfault.com, please click
Trouble rendering CSV data as an interactive table in GitHub
发布于 2020-11-30 13:49:46
When viewed, any .csv file committed to a GitHub repository automatically renders as an interactive table, complete with headers and row numbering. By default, the first row is your header row. The tables were supposed to look nice as below:
However, there's an error happening in my tabular data, and despite indicating the error, I can't fix it:
I'm using a csv file with a semicolon separator. Would anyone have an idea of what's happening?
Many thanks.
Questioner
Naomi
Viewed
0
Thanks for your answer! That makes sense, when I use tabs as a separator, it doesn't work. However, when I use a comma as separator, it does work. But I can't use the comma as the separator, as I have text variables that contain comma on it. I've seen other interactive tables with a comma in the text variables, I just wanted to figure it out how they managed that.
Tabs don't work? Hrmph. They should. Could you point me to one of those tables with commas in the text variables that does work properly? I'll have a look at how they do it. Also, see edited answer. Don't forget to vote and/or accept the answer if you find it, um, acceptable.
I found the problem! I was using the function write.table and the arg sep = "," to export the .csv file in R. But when I used the function write_csv from the reader package, it did work! Apparently, the write.table was breaking down the rows where the comma appeared in a text. Many thanks for your insights, ocrdu.