Pandas VS orange

Pandas is a go-to tool for tabular data management, processing, and analysis in Python, but sometimes you may want to go from pandas to SQL.

panda’s

> The big thing pandas has going for it is that it's already been through this field testing. All the bugs have been ironed out by the hundreds of thousands of users.

At this very moment pandas github repo has 1563 open issues labeled with a bug tag [0]. So much for "all the bugs have been ironed out".

[0] https://github.com/pandas-dev/pandas/issues?q=is%3Aopen+is%3...

Python is the main programming language I use nowadays. In particular numpy and pandas are of course extremely useful. I also use biopython package - a collection of software tools for biological computation written in Python by an international group of researchers and developers.

Below is the python Task that transforms the tweets list into a Pandas dataframe, then dumps it in our MinIO Object Storage as a CSV file:

It was rewarding to dig into SQLite a bit while solving this puzzle, so I figured this would be a good opportunity to learn a bit more about pandas too! So how would I adapt this working SQL solution to pandas?

All the data has been extracted from the official Tor Metrics website, and using Python with the Pandas library I've cleaned the data. Finally, the visualizations have been made with Tableau.

If you did that you could use a built-in library like csv to read and parse the file or you could use a 3rd party library like Pandas. Alternatively, you could store your file as json:

Honestly, I think ML should always involve at least a little bit of coding, which would be more practical. That said, this looks reasonable, good playground for experiment.

A good similar product is Orange: https://orangedatamining.com/

Actually....I thought of an interesting free option. Check out orange3. https://orangedatamining.com/

I love to play with my dataset using OrangeDatamining. Very easy to use. Docs and example available. It’s like Data Modeler from IBM but better bcos it is open project :-)

Currently, I am looking around for modules for Knime and Orange and looked at some of the modules, and realized that it does not have enough tools within their tool kit (e.g. text data analysis, network analysis, image classification).