Tutorial to write SQL queries using Python and visualizing the results in Tableau - Part 3

Another business problem for your SQL and tableau learning regime. Here we'd be dealing with the code and how to visualize it in Tableau.

Dataset: Vehicles.csv

What makes a car worth buying? It is the cost-effectiveness and a brand name that is linked to it. All the manufacturers in the industry are trying to give maximum features even in the lowest model. So a person either prefers a brand name or an economical price that he can afford.

We will learn how to analyze the given dataset using python codes and visualize the same result in Tableau.

SQL Query in Python

Following is the SQL query in Python

!pip install pandasql
import pandas as pd
pd.set_option('display.max_rows', 100)
pd.options.display.float_format = '{:.5f}'.format
import pandasql as ps
from IPython.display import HTML

sql_query = """
select avg(price) as average_price,manufacturer
from vehicles 
where (type="sedan") and (transmission="automatic") and 
 (price between 1 and 655000)
group by manufacturer
order by avg(price)
"""

res_df = ps.sqldf(sql_query, locals())
HTML(res_df.to_html(escape=False))

The following table will come as output:

The above table gives us the average price of the vehicle corresponding to the manufacturer(brand).

Visualizing the result in Tableau

Tableau is a tool to visualize your data in a way that you can filter the data using the price or the manufacturer's name as we have done in this blog.

Drag the Price and Manufacturer to Rows and Columns respectively.

Also dragging Transmission=automatic, Manufacturer, and Type=sedanto filter in the left.

To show the filters in the right corner we can right-click on a particular filter and click on show filter, as shown below:

Now, the SQL query demands the data should be filtered using the price range from 1 to 65,50,00.  Therefore, we add a price filter and select the given range and finally get the names of the manufacturers that were on top by averaging out the price of each.

We have plotted our result using a horizontal bar graph. Here, it is used to compare the various price among manufacturers.

The one with the largest spread is the one having the highest average pricing.

Bar Graph: A bar graph is a specific way of representing data using rectangular bars where the length of each bar is proportional to the value they represent. It is basically a graphical representation of data using bars of different heights.  

Here, we have Porsche with the maximum highest price.

Conclusion

We have plotted our SQL query in Tableau and also learned how to use and show filters to sort them out.

This was a quick guide to visualize your SQL queries in Tableau using a bar graph.

Hope this was helpful.

Stay tuned for the upcoming Tableau series.