Did you know that you can apply styles to your Pandas visualization?
Let's take a brief look at it π
[1 min]
1/8π§΅
Let's take a brief look at it π
[1 min]
1/8π§΅
Now that you have loaded the data, it's very important to understand it.
To help with that it's good to be able to read it properly and formatting the data definitely help!
Let's come back to the New York Taxi fare
2/8π§΅
To help with that it's good to be able to read it properly and formatting the data definitely help!
Let's come back to the New York Taxi fare
2/8π§΅
The fare amount is money.
To format a financial value in Python, we would use the string format "${15,.2f}"
Pandas has a style object and a very similar format method:
3/8π§΅
To format a financial value in Python, we would use the string format "${15,.2f}"
Pandas has a style object and a very similar format method:
3/8π§΅
But how about that date column? We don't need all those zeros.
Let's just show a simple iso format. To do that we can use: strftime('%Y-%m-%d')
You can use a lambda function to apply that to the column (in a previous thread we already casted it to datetime)!
4/8π§΅
Let's just show a simple iso format. To do that we can use: strftime('%Y-%m-%d')
You can use a lambda function to apply that to the column (in a previous thread we already casted it to datetime)!
4/8π§΅
How big are the values compared to the average of the column? To know that, we can add some bars per cell!
This can give a good insight on the size of numerical values.
5/8π§΅
This can give a good insight on the size of numerical values.
5/8π§΅
How about adding some more color.
The higher the value we will paint with a darker color
In our case green but you can use any of the Matplotlib colormap options
This can also be applied per row or per column
6/8π§΅
The higher the value we will paint with a darker color
In our case green but you can use any of the Matplotlib colormap options
This can also be applied per row or per column
6/8π§΅
You usually will not see all your rows unless you have a very basic dataset.
Ideally you'd use this styling in one of the 2 use cases:
β’ A sample or projection of the data
β’ The descriptive statistics view (describe method)
7/8π§΅
Ideally you'd use this styling in one of the 2 use cases:
β’ A sample or projection of the data
β’ The descriptive statistics view (describe method)
7/8π§΅
To understand data you need all the help you can get, giving some visual clues to your eyes is very welcome! ποΈπ
Don't forget to share this thread with your friends and let's make some colorful reports!
And if you're not following me yet, you're missing out!π
8/8π§΅
Don't forget to share this thread with your friends and let's make some colorful reports!
And if you're not following me yet, you're missing out!π
8/8π§΅
β’ β’ β’
Missing some Tweet in this thread? You can try to
force a refresh
γ
