DEV Community

Cover image for [Apache Superset] Topic #3, Visualization data from CSV data file
Duc Nguyen Thanh
Duc Nguyen Thanh

Posted on

[Apache Superset] Topic #3, Visualization data from CSV data file

Hello, it's me again - Duc Nguyen (Duke)

Before starting this tutorial, you should have mastered the previous two tutorials in the Apache Superset tutorial series.

  • Topic #1, What is Apache Superset used for and how to install it on Windows 11 here
  • Topic #2, Superset ARCHITECTURE here

Okay, let's get started with today's topic: How to get data from CSV files and visualization them

First thing, you need to have sample data in CSV format, here I use insurance claim information data here
CSV dataset

Okay, now let's import this CSV file into Superset and then visualize the data through charts.

Click the + button then find and select Upload CSV to database
Upload CSV
and we have many settings here like Delimiter, Decimal Character, If Table Already Exists
Upload options
Next, click the Edit icon button in the DucNguyen dataset and you will see the dialog box shown below
Calculated columns
then click the Add item in the Calculated columns

CASE WHEN CLMSEX = 1 THEN 'Male' ELSE 'Female' END
Enter fullscreen mode Exit fullscreen mode

SQL expression

Next, click the Create chart button in the Chart tab
Create a chart

And here is the result you get a pie chart showing the number of insurance claims by gender, the settings here are very easy to understand, you can refer to my settings in the image below

result result2

Do you have any questions? See you in the next topic!

Do your career a big favor. Join DEV. (The website you're on right now)

It takes one minute, it's free, and is worth it for your career.

Get started

Community matters

Top comments (0)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay