Create an account


Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Tut] How to Calculate the Column Standard Deviation of a DataFrame in Python Pandas?

#1
How to Calculate the Column Standard Deviation of a DataFrame in Python Pandas?

Want to calculate the standard deviation of a column in your Pandas DataFrame?

In case you’ve attended your last statistics course a few years ago, let’s quickly recap the definition of variance: it’s the average squared deviation of the list elements from the average value.



You can do this by using the pd.std() function that calculates the standard deviation along all columns. You can then get the column you’re interested in after the computation.

import pandas as pd # Create your Pandas DataFrame
d = {'username': ['Alice', 'Bob', 'Carl'], 'age': [18, 22, 43], 'income': [100000, 98000, 111000]}
df = pd.DataFrame(d) print(df)

Your DataFrame looks like this:


username age income
0 Alice 18 100000
1 Bob 22 98000
2 Carl 43 111000

Here’s how you can calculate the standard deviation of all columns:

print(df.std())

The output is the standard deviation of all columns:

age 13.428825
income 7000.000000
dtype: float64

To get the variance of an individual column, access it using simple indexing:

print(df.std()['age'])
# 180.33333333333334

Together, the code looks as follows. Use the interactive shell to play with it!

Standard Deviation in NumPy Library


Python’s package for data science computation NumPy also has great statistics functionality. You can calculate all basic statistics functions such as average, median, variance, and standard deviation on NumPy arrays. Simply import the NumPy library and use the np.var(a) method to calculate the average value of NumPy array a.

Here’s the code:

import numpy as np a = np.array([1, 2, 3])
print(np.std(a))
# 0.816496580927726

Where to Go From Here?


Before you can become a data science master, you first need to master Python. Join my free Python email course and receive your daily Python lesson directly in your INBOX. It’s fun!

Join The World’s #1 Python Email Academy [+FREE Cheat Sheets as PDF]



https://www.sickgaming.net/blog/2020/04/...on-pandas/
Reply



Forum Jump:


Users browsing this thread:
1 Guest(s)

[-]
Discord

[-]
Active Threads
News - Guide: Best Nintendo Switch Puzzl...
Last Post: xSicKxBot
Today 08:56 AM
» Replies: 0
» Views: 2
News - The Biggest Gaming News Stories O...
Last Post: xSicKxBot
Today 08:56 AM
» Replies: 0
» Views: 0
Are you still excited about the resurrec...
Last Post: Ulrica
Today 03:24 AM
» Replies: 0
» Views: 20
Can the player have two animal crossings...
Last Post: Sellen
Today 02:58 AM
» Replies: 0
» Views: 11
(Indie Deal) Cozy Grove, Iceberg, The Cr...
Last Post: xSicKxBot
Today 02:47 AM
» Replies: 0
» Views: 5
Microsoft - Aliens: Fireteam Elite avail...
Last Post: xSicKxBot
Today 02:47 AM
» Replies: 0
» Views: 3
News - GamesMaster: Episode 2 Heaps Prai...
Last Post: xSicKxBot
Today 02:47 AM
» Replies: 0
» Views: 3
News - Stardew Valley Patch 1.5.5 Adds E...
Last Post: xSicKxBot
Today 02:47 AM
» Replies: 0
» Views: 5
(Indie Deal) Tales of Arise, Paradox, Ko...
Last Post: xSicKxBot
Yesterday 11:09 PM
» Replies: 0
» Views: 14
News - Looks Like Pokémon GO’s Next Seas...
Last Post: xSicKxBot
Yesterday 11:09 PM
» Replies: 0
» Views: 4

[-]
Twitter

[-]
Sponsored
Get the Deal of the Week at RefurBees.com



Discord Server © SickGaming.net 2012-2021