- Trending Categories
- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Python - Round number of places after the decimal for column values in a Pandas DataFrame
To round number of places after the decimal, use the display.precision attribute of the Pandas.
At first, import the required Pandas library −
import pandas as pd
Create a DataFrame with 2 columns −
dataFrame = pd.DataFrame( { "Car": ['BMW', 'Lexus', 'Tesla', 'Mustang', 'Mercedes', 'Jaguar'], "Reg_Price": [7000.5057, 1500, 5000.9578, 8000, 9000.75768, 6000] } )
Use the set_option() method to set precision. We have set precision value 2 −
pd.set_option('display.precision', 2)
Example
Following is the complete code −
import pandas as pd # Create DataFrame dataFrame = pd.DataFrame( { "Car": ['BMW', 'Lexus', 'Tesla', 'Mustang', 'Mercedes', 'Jaguar'], "Reg_Price": [7000.5057, 1500, 5000.9578, 8000, 9000.75768, 6000] } ) print"DataFrame ...\n",dataFrame pd.set_option('display.precision', 2) print"\nUpdated dataframe with rounding decimal values...\n", dataFrame
Output
This will produce the following output −
DataFrame ... Car Reg_Price 0 BMW 7000.50570 1 Lexus 1500.00000 2 Tesla 5000.95780 3 Mustang 8000.00000 4 Mercedes 9000.75768 5 Jaguar 6000.00000 Updated dataframe with rounding decimal values... Car Reg_Price 0 BMW 7000.51 1 Lexus 1500.00 2 Tesla 5000.96 3 Mustang 8000.00 4 Mercedes 9000.76 5 Jaguar 6000.00
Advertisements