skip second row of dataframe while reading csv file in python

115

Sarang Kapse

I am unable to skip the second row of a data file while reading a csv file in python.

I am using the following code :

imdb_data = pd.read_csv('IMDB_data.csv', encoding = "ISO-8859-1",skiprows = 2)

Matina G

Your code will ommit the first two lines of your csv. If you want the second line to be ommitted (but the first one included) just do this minor change:

imdb_data = pd.read_csv('IMDB_data.csv', encoding = "ISO-8859-1",skiprows = [1])

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-10-30

Comments

0 comments

How to skip lines while reading a CSV file as a dataFrame using PySpark?

Error while reading csv file and returning dataframe in python

wrong schema while reading csv file as a dataframe

How to skip the first row when reading a csv file?

Skip blank lines while reading .csv file using opencsv (java)

skip header while reading a CSV file in Apache Beam

Skip header of CSV file while reading in core Java with below approach

Skip first couple of lines while reading lines in Python file

Reading a particular row in csv file with Python

KeyError while reading a CSV file in Python

Python: Replace values while reading CSV file

Error while reading csv file using python

Read the second row from CSV file to Python

Skip the first column when reading a csv file Python

In GCP python cloud function, dataframe is putting ' ' in the end while reading csv file

Skip Header Row when reading in a CSV

How to skip second line is csv file while maintaining first line as column names with read_csv?

Reading a txt file line by line with skip function of every second line and the output saved as a dataframe using R

Issue while writing/reading a dataframe to csv - in final shape - Python

How to skip carriage returns in csv file while reading from cloud storage using google cloud dataflow in java

How can I skip even/odd rows while reading a csv file?

Missing first row while reading from file - Python Pandas

Spark csv to dataframe skip first row

Ruby CSV | How to skip few columns while reading CSV?

Reading last non-empty cell in row of CSV file with Python

Python: Replace values while reading CSV file with pandas

Python pandas error while reading and writing csv file

python rstrip usage within loop while reading csv file

TOP Ranking

Article

skip second row of dataframe while reading csv file in python

skip second row of dataframe while reading csv file in python

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

How to import an asset in swift using Bundle.main.path() in a react-native native module

pump.io port in URL

Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

BigQuery - concatenate ignoring NULL

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

How to remove the extra space from right in a webview?

java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

flutter: dropdown item programmatically unselect problem

How to use merge windows unallocated space into Ubuntu using GParted?

Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

Nuget add packages gives access denied errors

Svchost high CPU from Microsoft.BingWeather app errors

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

12.04.3--- Dconf Editor won't show com>canonical>unity option

Any way to remove trailing whitespace *FOR EDITED* lines in Eclipse [for Java]?

maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

Any way to remove trailing whitespace FOR EDITED lines in Eclipse [for Java]?