Skip to main content
16 votes

Is there a software tool which allows to perform SQL on CSV files?

Have a look at q q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). https://github.com/harelba/q
Benjamin Crouzier's user avatar
10 votes

Is there a software tool which allows to perform SQL on CSV files?

The 'problem' with a CSV file is that the single 'table' doesn't have a name. Therefore, you'll need to define a table (including columns) and import the CSV file before doing any SQL queries on it. ...
Glorfindel's user avatar
  • 2,035
4 votes

Is there a software tool which allows to perform SQL on CSV files?

If you have the flexibility to use some light scripting languages try - R script - It has sqldf library which can be used to run sql queries on dataframes. You just have to read your csv into a ...
skybunk's user avatar
  • 141
4 votes

Is there a software tool which allows to perform SQL on CSV files?

Try csvsql. It is part of csvsuite, a suite of command line tools written in python, since March 2019 tested against Python 3.7. The csvkit tools are described in the book Data Science at the ...
knb's user avatar
  • 2,960
4 votes

Is there a software tool which allows to perform SQL on CSV files?

Using PostgreSQL and DBeaver is another option. PostgreSQL is a sophisticated, open source database system. It allows for importing CSV files through the COPY command and through graphical UIs such as ...
Lars Helge Øverland's user avatar
3 votes
Accepted

Is there a better software/library towards analytics (and visualisation)?

You don't mention where these data are stored, so I guess it's on a database. If you are looking for something Open Source, Free and on-premises have a look at Metabase. It takes really just 5 ...
Sonamor's user avatar
  • 1,133
3 votes
Accepted

IDE with debugger able to view and manipulate python pandas dataframes?

Is there an IDE that correctly displays pandas dataframes? PyCharm released version 2016.2 (a week after I posted this question!), which includes a pandas dataframe viewer. I still want to know if ...
Mark Teese's user avatar
3 votes

Is there a software tool which allows to perform SQL on CSV files?

SQLite is a nice lightweight tool that is supported by multiple languages. If you use Python, there are several tools in the Python Package Index (pypi.org) that make it easy to use (including https:/...
rd_nielsen's user avatar
3 votes

Is there a software tool which allows to perform SQL on CSV files?

Try RBQL - it provides SQL-like dialect with Python or Javascript expressions. You can use RBQL from the command line (RBQL in pip) And from Rainbow CSV text editor extensions which provide nice GUI ...
user150547's user avatar
3 votes

Is there a software tool which allows to perform SQL on CSV files?

I know I'm late to the party, but I've created a Desktop app that can perform SQL on a bunch of CSV files. It is a Desktop app because it can easily handle a 600MB CSV file (only taking ~15 seconds to ...
Tanin's user avatar
  • 131
2 votes

Heatmap chart generator for table/matrix data

Gnuplot should fit your needs. It's a portable command-line driven graphing utility for Linux, OS/2, MS Windows, OSX, VMS, and many other platforms. It's relatively easy to use and you will find many ...
Fabio Silva's user avatar
2 votes

Is there a better software/library towards analytics (and visualisation)?

Syncfusion Dashboard is an end to end Dashboard solution. The Dashboard Designer can be used for data analysis and visualization. The dashboard can be deployed with the dashboard server or embedded ...
Davis Jebaraj's user avatar
2 votes

Is there a better software/library towards analytics (and visualisation)?

I would recommend Tableu. It is an excellent package especially for displaying data and building histograms. It is totally point and click except for defining certain equations or number of bins for a ...
Natsfan's user avatar
  • 894
2 votes
Accepted

Software to make text analysis of csv file

There is - the combination of python/jupyter and Pandas is excellent for this sort of thing. Open Source & Gratis Read large CSV files Lots of data analysis & visualisation tools Cross ...
Steve Barnes's user avatar
  • 31.7k
2 votes

Something like Google Trends for scientific papers?

I am interested in this topic myself. You can get a long way by searching other literature databases, and by using the Stackexchange data explorer. Recently I have counted the frequency of ...
knb's user avatar
  • 2,960
2 votes

Software specialization for actuarial and data science

Most data science seems to be using either python or R. Both are free but have somewhat steep learning curves. There are plenty of tutorials for both. R is often run using R-studio, a gui wrapper ...
Natsfan's user avatar
  • 894
2 votes

Is there a better software/library towards analytics (and visualisation)?

Zeppelin I just recently learned of this application and it may be just what you need. It's free and open source. I haven't used it myself but the description sounds similar to Tableu (without the ...
Natsfan's user avatar
  • 894
2 votes

Tools for big CSV files manipulations

You could try datamash https://www.gnu.org/software/datamash/manual/datamash.html Also importing your records into mysql. importing into sqlite. sqlite> .mode csv sqlite> .import test.csv ...
cybernard's user avatar
  • 1,726
2 votes
Accepted

Command line tool to analyze amount of motion in video file

1.VLC has a motion detection filter that you can try by accessing: Tools -> Effects and Filters -> Video Effects -> Advanced -> Motion Detect. Check this out for CLI tools. 2.DVR-Scan is a cross-...
Akankshya Mishra's user avatar
2 votes

Is there a software tool which allows to perform SQL on CSV files?

Flatbase is a free web app that allows you to query CSV, JSON, and other flat files using SQL. You can also graph results and share with colleagues.
mockaroodev's user avatar
2 votes

What would be a suitable tool to do time series data comparison?

The commonly-used scripting languages include SQL, Python Pandas and esProc. The SQL query is quite simple when using the window function: select transDate,price, price/lag(price) over(order ...
Elsa Jessica's user avatar
2 votes

Open and visually browse large CSV files

I've been using EmEditor for years. Can open practically any size file (up to 248GB realistically) and can split CSV and other delimited text into columns. With tons of other features. There's a ...
BlueGI's user avatar
  • 151
2 votes

What BI/Dashboard tool is best for embedding into a web application?

Bold BI dashboards can be embedded in two ways: JavaScript-based embedding and iFrame-based embedding. In both the embedding ways, BI login can be integrated with your application through SSO ...
user83283's user avatar
1 vote

Data analysis tool for Java

You can try Weka. It is implemented in Java, has several GUIs and can be called via the command line, or by importing the package(s) into Java code. Weka can import CSV files, but it works best with ...
knb's user avatar
  • 2,960
1 vote

Open source GUI tool for data wrangling with little or no programming

I suggest you to use OpenRefine. You first need to add a new column based on the ID and NAME columns, e.g. using this expression: cells["ID"].value + ";" + cells["NAME"].value Sorting by the new ...
myrdd's user avatar
  • 131
1 vote

Software specialization for actuarial and data science

Personally I would suggest taking a look at what can be done with the combination of Python, Pandas & Jupyter - all are free, (gratis & open source) and cross platform. They willl allow you to ...
Steve Barnes's user avatar
  • 31.7k
1 vote

Tools for big CSV files manipulations

The ideal tool for this is a python tool called Pandas. Free, Gratis & Open Source Cross Platform Can handle huge data sets Intelligent label-based slicing, fancy indexing, and subsetting of ...
Steve Barnes's user avatar
  • 31.7k
1 vote

Topological Data Analysis Libraries for Python

The GUDHI library is mostly written in C++, but it comes with Python bindings, and even a few Python-only functionalities. If you have used the TDA package in R, you may have already indirectly used ...
Marc Glisse's user avatar
1 vote

JavaScript library that easily customizes time period and interval in line charts

Syncfusion provides a chart control ejChart. Here is a sample that mimics Google Analytics link The start time, end time and interval can be customized as needed. The entire product is available for ...
Davis Jebaraj's user avatar
1 vote

How to convert stanza based data to row based?

Easier way for whom? As I understand, you would like to have the data broadly in the form: name1 balance1 cardid1 firstaddress1 ... name2 balance2 cardid2 firstaddress2 ... ... This seems to ...
Ott Toomet's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible