News for hackers. Stuff that matters.

A comment on Scientists rename human genes to stop MS Excel from misreading them as dates. Parent comment

Re:Scientists rename human genes to stop MS Excel from misre... by goatlover on Thursday August 06, 2020 @05:25PM (#24075616)
> good with excel/Google Sheets and SQL

Those aren't very good for cleaning and wrangling data, even if the output for analysis ends up being a spreadsheet.

[ Parent | on HN ]
Re:Scientists rename human genes to stop MS Excel from misre... by importantbrian on Friday August 07, 2020 @02:44PM (#24085155)
Agreed that spreadsheets aren't great for that, but totally disagree about SQL. SQL is the best cleaning and wrangling data tool out there. There's a reason the trend in the industry is towards tools like DBT. There are certainly things for which you need to use Python or R, but for 95% of tasks some combination of SQL and a spreadsheet will get you where you need to go.
[ Parent | on HN ]