Jupyter

My process is like this: I would get data once a month, either from Google BigQuery or as parquet files from Azure Blob Storage. I have a script that does some cleaning and then stores the result as partitioned parquet files because the following process cannot handle loading all data to memory.

The next process is making a heavy computation in a parallel fashion (per partition), and storing 3 intermediate versions as parquet files: two used for statistics, and the third will be filtered and create the final files.

I make a report based on the two files in Jupyter notebook and convert it to HTML.

• Everything is done with vanilla python and Pandas.
• sometimes I may get a different format of data
• cloud service is Microsoft Azure.

What I'm considering is the following:

Get the data with Kafka or with native python, do the first processing, and store data in Druid, the second processing will be done with Apache Spark getting data from apache druid.

the intermediate states can be stored in druid too. and visualization would be with apache superset.

From my point of view, both OpenRefine and Apache Hive serve completely different purposes. OpenRefine is intended for interactive cleaning of messy data locally. You could work with their libraries to use some of OpenRefine features as part of your data pipeline (there are pointers in FAQ), but OpenRefine in general is intended for a single-user local operation.

I can't recommend a particular alternative without better understanding of your use case. But if you are looking for an interactive tool to work with big data at scale, take a look at notebook environments like Jupyter, Databricks, or Deepnote. If you are building a data processing pipeline, consider also Apache Spark.

Edit: Fixed references from Hadoop to Hive, which is actually closer to Spark.

I am learning Python coding and doing lots of hands on python problem. I like the feel of Jupyter notebook but I have concern will that slow my computer performance. Will PyCharm or Jupyter or Atom-IDE is good for python coding?

Jupyter Anaconda Pandas IPython

A great way to prototype your data analytic modules. The use of the package is simple and user-friendly and the migration from ipython to python is fairly simple: a lot of cleaning, but no more.

The negative aspect comes when you want to streamline your productive system or does CI with your anaconda environment: - most tools don't accept conda environments (as smoothly as pip requirements) - the conda environments (even with miniconda) have quite an overhead

I use Jupyter and JupyterLab specifically because it's such a great interface for Python, SQL, data exploration, and data viz. Documentation is built into the design of a notebook, and it's commonly used enough in people's workloads that not much educating is required.

I know some on G Suite like using CoLab, but it runs pretty slow and disconnects runtimes often.

Here's a fun little example to make it feel more real Jupyter/CoLab Example

When integrated with cloud platforms it's an easy way to code and test data science projects. The web-based nature makes it easy to transition between coding on your local machine or the cloud. Jupyter