News for hackers. Stuff that matters.
Re:The CSV Virtual Table by geokon on Friday March 11, 2022 @02:04AM (#30637151)
So then the question is.. why have R/Python/etc. reinvented the wheel with their own datatable structures instead of using SQL?
Re:The CSV Virtual Table by faizshah on Friday March 11, 2022 @04:19PM (#30646146)
It’s not really reinventing the wheel, I make use of sql, pandas, pyspark, sparksql, data.table, bigquery, it all depends on the use case.

Dataframe abstractions are really easy to understand so I have worked with journalists and biologists who are able to work productively with pandas or R. Transforming and analyzing data is often easier to write with pyspark while spark sql makes it easy to access and extract data from some data sources.

It all really depends on who is your customer, who are your coworkers, how much volume of data do you have, how much time do you have to accomplish your task etc.