- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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 Pandas – How to skip initial space from a DataFrame
To skip initial space from a Pandas DataFrame, use the skipinitialspace parameter of the read_csv() method. Set the parameter to True to remove extra space.
Let’s say the following is our csv file −
We should get the following output i.e. skipping initial whitespace and displaying the DataFrame from the CSV −
Example
Following is the complete code −
import pandas as pd
# reading csv file
dataFrame = pd.read_csv("C:\Users\amit_\Desktop\CarRecords.csv")
print("DataFrame...
",dataFrame)
# reading csv file and removing initial space
dataFrame = pd.read_csv("C:\Users\amit_\Desktop\CarRecords.csv", skipinitialspace = True)
print("DataFrame...
",dataFrame)At first, read the CSV. Our CSV file is on the Desktop −
dataFrame = pd.read_csv("C:\Users\amit_\Desktop\CarRecords.csv")While reading, you can set the skipinitialspace parameter and remove whitespace −
dataFrame = pd.read_csv("C:\Users\amit_\Desktop\CarRecords.csv", skipinitialspace = True)Output
This will produce the following output −
DataFrame... Car Place UnitsSold 0 Audi Bangalore 80 1 Porsche Mumbai 110 2 RollsRoyce Pune 100 3 BMW Delhi 200 4 Mercedes Hyderabad 80 5 Lamborghini Chandigarh 80 6 Audi Mumbai 60 7 Mercedes Pune 120 8 Lamborghini Delhi 100 DataFrame... Car Place UnitsSold 0 Audi Bangalore 80 1 Porsche Mumbai 110 2 RollsRoyce Pune 100 3 BMW Delhi 200 4 Mercedes Hyderabad 80 5 Lamborghini Chandigarh 80 6 Audi Mumbai 60 7 Mercedes Pune 120 8 Lamborghini Delhi 100
Updated on 28-Sep-2021 12:11:30
- Related Questions & Answers
- Python - How to select a column from a Pandas DataFrame
- Python Pandas - How to delete a row from a DataFrame
- Python Pandas - How to select multiple rows from a DataFrame
- How to delete a column from Pandas DataFrame
- Python Pandas - Create Multiindex from dataframe
- Python - How to drop the null rows from a Pandas DataFrame
- Python – Strip whitespace from a Pandas DataFrame
- Python - Remove duplicate values from a Pandas DataFrame
- Python - Select multiple columns from a Pandas dataframe
- How to delete a column from a Pandas DataFrame?
- Python Pandas - How to select rows from a DataFrame by integer location
- C# Program to skip initial elements in an array
- Python Pandas - Select a subset of rows from a dataframe
- Python Pandas - How to append rows to a DataFrame
- Python Pandas - How to select rows from a DataFrame by passing row label
Advertisements