如何计算熊猫一栏的百分比？
A 百分比由数值除以所有数值之和再乘以 100 的数学公式计算得出。这也适用于熊猫数据帧。这里，熊猫系列的预定义 sum() 方法用于计算一列所有值的总和。
语法: Series.sum()
返回:返回数值之和。
公式:
df[percent] = (df['column_name'] / df['column_name'].sum()) * 100
例 1:
Python 3
# Import required libraries
import pandas as pd
import numpy as np
# Dictionary
df1 = {
'Name': ['abc', 'bcd', 'cde',
'def', 'efg', 'fgh',
'ghi'],
'Math_score': [52, 87, 49,
74, 28, 59,
48]}
# Create a DataFrame
df1 = pd.DataFrame(df1,
columns = ['Name',
'Math_score'])
# Calculating Percentage
df1['percent'] = (df1['Math_score'] /
df1['Math_score'].sum()) * 100
# Show the dataframe
df1
输出:
例 2:
Python 3
# Import pandas library
import pandas as pd
# Dictionary
df1 = {
'Name': ['abc', 'bcd', 'cde',
'def', 'efg', 'fgh',
'ghi'],
'Math_score': [52, 87, 49,
74, 28, 59,
48],
'Eng_score': [34, 67, 25,
89, 92, 45,
86]
}
# Create a DataFrame
df1 = pd.DataFrame(df1,
columns = ['Name',
'Math_score','Eng_score'])
# Calculate Percentage
df1['Eng_percent'] = (df1['Eng_score'] /
df1['Eng_score'].sum()) * 100
# Show the dataframe
df1
输出:
版权属于：月萌API www.moonapi.com，转载请注明出处
