Reply to post: Some habits are hard to break

A certain millennial turned 30 recently: Welcome to middle age, Microsoft Excel v2

Morten Bjoernsvik

Some habits are hard to break

Nice to hear people still using Excel and SQL for analytics, when a general purpose programming language and dataframe support makes it so much easier.

I worked years creating fraud reports in perl from large sql-databases, where the output had to be an excel spreadsheet. My major concerns were the 64K row limit and the crappy positioning. I alsways spent more than 60% of the time on Excel presentation.

Now I do python with dataframes using pandas and store it in a nosql elasticsearch database. I then import them into R for final analysis and presentation. In a nosql database you can store dataframes directly, it is like a multidimensional sql database. no more issues with positioning within the spreadsheet and presentation follows using the R cran modules.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon


Biting the hand that feeds IT © 1998–2020