It’s easy to use and doesn’t mess up my data. While it doesn’t solve the particular problem I have here, it’s really cool! It is an improved diff for CSV files that understands rows and columns, not just lines, so you can more easily see what actually changed in the file. I don’t have any experience with Atom or emacs, so I didn’t try either of these, but I think they might work pretty well for the right person.Īirtable, a cloud-based database tool consisting of tables you can edit, was also mentioned and seems like a cool and useful program, but the idea of uploading and downloading a file every time was too much overhead for me.ĭaff (data diff) also got a mention. In particular, the tablr plugin for the Atom text editor and csv-mode in Emacs were recommended. Two people suggested using your favorite text editor with a CSV plugin. But I really like the idea of an office suite designed with reproducible research in mind. ![]() It seems to be in early stages of development and, as far as I can tell, doesn’t yet have a way to open CSV or XLSX files. Stencila seems like an interesting program, calling itself “the office suite for reproducible research”. Other programsĪ bunch of other programs were suggested that don’t neatly fit into one category, so I’m lumping them together here. I could imagine using it for viewing files with thousands of rows though. Each mangled parts of my test file, but each in its own way.īut it is read-only (and won’t open XLSX files) so wouldn’t work for my editing needs. I tried this out with Excel, Google Sheets, and LibreOffice Calc, with similar results across all three. Spreadsheet programs are the obvious choice for editing CSV files, but they are also what led me here in the first place. With those criteria established, I went ahead and checked out the recommended programs, in three categories: spreadsheet programs, CSV-focused solutions, and other solutions. I tested this by opening an XLSX file from a collaborator and making all the changes it needed. ![]() My second criterion was that I should easily be able to edit the file in question. So my first criterion was that the ideal program would change nothing about any entry in this file. To try out the various solutions, I created a small test.csv containing a bunch of entries that I know have caused problems in the past: gene names that look like dates (“MARCH1”), gene identifiers that look like numbers (“2310009E13”), a date, and a variety of numbers that tend to get reformatted. But sometimes I receive files from collaborators that are so idiosyncratically formatted that it’s just not worth the effort to clean them up in code. Yes, yes, in a perfect world I would make all changes to the data with code. Particular problems are conversions of text like 1:200, 1/25, and MARCH1 into numbers or dates. I want to be able to open and edit Excel and CSV files and edit them freely without having any conversions done. Further suggestions and feedback are welcome. In this question I’ll give my impression of the programs. But sometimes I still need to manually edit files from collaborators.Īnd I got a bounty of suggestions from the helpful rOpenSci community. You could swap between text or Spreadsheet styleįor update directly source text.In a fit of pique I asked on rOpenSci slack:Īny recommendations for a CSV editor (or spreadsheet program generally) that won’t do anything to the data? I’m at my wits’ end with Excel turning 1:200 into 0.180555 and gene names into dates. So, You can create an order form file and you could enter customer orders on the file then send that to your company You could use this application for a lot of reasons such as sales price list, sales order, product list, etc. You could edit cells with a simple double tapping on it. You could add,remove, etc row or columns by tapping at label button. Update or create an CSV file is very easy. You could set list seperator ',' or ' ' or any other character, and set the encoding character set. When you finish your update you could send file to someone with e-mail or export file to other App. After that you could edit/view those file easily from this application on iPhone or iPad. ![]() When you open attached file it will copy itself into this application.
0 Comments
Leave a Reply. |