Do you think there's hope if I try with MS Excel?
-
-
Dropbox allows you to open files in Web Excel, right?
2 replies 0 retweets 0 likes -
Will try, thank you.
2 replies 0 retweets 2 likes -
No idea if this will help you as I'm not sure if you need a wysiwyg, but you can always open this in Python as a pandas dataframe or in R as a dataframe.
1 reply 0 retweets 0 likes -
I actually identified these issues when loading it in R with readxl::read_xlsx. I looked them up in the spreadsheet editors I had at hand.
2 replies 0 retweets 1 like -
So is it an issue with the data or how spreadsheet software wants to auto convert? I know the same thing can happen with csv files in excel...
1 reply 0 retweets 1 like -
Replying to @Hao_and_Y @o_guest and
Well, I'm not sure, to be honest. Some cells happen to trigger this. I tried to change the formatting of the cell, but it seems to be defined as numeric, despite the partial date.
2 replies 0 retweets 1 like -
Replying to @lgatt0
Sounds like it may have gotten borked before it got to you then!
1 reply 0 retweets 1 like -
Replying to @Hao_and_Y
Guess where I got it from? A supplementary file from a paper!
1 reply 0 retweets 2 likes -
Replying to @lgatt0
Hah, could be the journal’s fault if they only allow xlsx and not csv, and then authors careless with conversion!
1 reply 0 retweets 2 likes
Oh noes. Maybe ask authors?
-
-
Replying to @o_guest @Hao_and_Y
Yes, will do that. Thank you for your help
0 replies 0 retweets 2 likesThanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.