快捷導(dǎo)航

Pandas格式化DataFrame的浮點(diǎn)數(shù)列的實(shí)現(xiàn)

更新時(shí)間：2024年05月30日 10:34:06 作者：python收藏家

本文主要介紹了Pandas格式化DataFrame的浮點(diǎn)數(shù)列的實(shí)現(xiàn),文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧

例1：將列值四舍五入到兩位小數(shù)

# import pandas lib as pd 
import pandas as pd 

# create the data dictionary 
data = {'Month' : ['January', 'February', 'March', 'April'], 
	'Expense': [ 21525220.653, 31125840.875, 23135428.768, 56245263.942]} 

# create the dataframe 
dataframe = pd.DataFrame(data, columns = ['Month', 'Expense']) 

print("Given Dataframe :\n", dataframe) 

# round to two decimal places in python pandas 
pd.options.display.float_format = '{:.2f}'.format

print('\nResult :\n', dataframe)

在這里插入圖片描述

例2：用逗號(hào)格式化整數(shù)列，并四舍五入到兩位小數(shù)

# import pandas lib as pd 
import pandas as pd 

# create the data dictionary 
data = {'Month' : ['January', 'February', 'March', 'April'], 
		'Expense':[ 21525220.653, 31125840.875, 23135428.768, 56245263.942]} 

# create the dataframe 
dataframe = pd.DataFrame(data, columns = ['Month', 'Expense']) 

print("Given Dataframe :\n", dataframe) 

# Format with commas and round off to two decimal places in pandas 
pd.options.display.float_format = '{:, .2f}'.format

print('\nResult :\n', dataframe)

在這里插入圖片描述

例3：格式劃列與逗號(hào)和$符號(hào)，并四舍五入到兩位小數(shù)

# import pandas lib as pd 
import pandas as pd 

# create the data dictionary 
data = {'Month' : ['January', 'February', 'March', 'April'], 
		'Expense':[ 21525220.653, 31125840.875, 23135428.768, 56245263.942]} 

# create the dataframe 
dataframe = pd.DataFrame(data, columns = ['Month', 'Expense']) 

print("Given Dataframe :\n", dataframe) 

# Format with dollars, commas and round off 
# to two decimal places in pandas 
pd.options.display.float_format = '${:, .2f}'.format

print('\nResult :\n', dataframe)

在這里插入圖片描述

到此這篇關(guān)于Pandas格式化DataFrame的浮點(diǎn)數(shù)列的實(shí)現(xiàn)的文章就介紹到這了,更多相關(guān)Pandas DataFrame浮點(diǎn)數(shù)列內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: