在Pandas中对数据框架的浮动列进行格式化

在展示数据时，以所需的格式展示数据也是一个重要和关键的部分。有时，数值太大，我们只想显示其中所需的部分，或者我们可以说以某种所需的格式。

让我们看看在Pandas中对Dataframe的整数列进行格式化的不同方法。

代码#1 :将列值四舍五入到小数点后两位。

# 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 : ‘Expense’一栏的格式为逗号，并四舍五入到小数点后两位。

# 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 :“支出 “一栏的格式为逗号和美元符号，有两个小数位。

# 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)

输出: