Passing multiple arguments while reading a CSV file in Python

Question

I am trying to read the csv file using pandas, while reading I want to read only few rows and few columns for that I can pass all the arguments like skiprows, nrows inside pd.read_csv. But I don't want to do this way I want to create a separate function and pass this function to pd.read_csv as shown below. Can anyone tell me how to achieve this.

import pandas as pd
file = r'C:\Users\Desktop\raw_data\Parameters.csv'

def readheader():
parse_config
{
    'nrows': 200,
    'header': [1,4],
    'skip_blank_lines': True
}
df = pd.read_csv(file, **parse_config)
print(df)
df.head()

user2263572 · Accepted Answer · 2020-03-03 18:12:51Z

1

You can do this:

def someFunction(filepath_or_buffer, skip_blank_lines):
  parse_config = {
      'filepath_or_buffer': filepath_or_buffer,
      'skip_blank_lines': skip_blank_lines
  }
  df = pd.read_csv(**parse_config)

someFunction(filepath_or_buffer='/some_path', skip_blank_lines=False)

keys in your parse_config object have to be valid parameters

Without modifying the pandas source code, you can't change what parameters are able to be passed to the read_csv method.

edited Mar 3, 2020 at 18:12

answered Mar 3, 2020 at 18:05

user2263572

5,6165 gold badges40 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

atheesh_27 Over a year ago

This doesn't work now. I got this error. ValueError: Invalid file path or buffer object type: <class 'dict'>

user2263572 Over a year ago

@atheesh27 without more info (your code, version of pandas, version of python) it's difficult to understand your issue.

atheesh_27 Over a year ago

Sorry ! it did work. I upvoted the answer.

Collectives™ on Stack Overflow

Passing multiple arguments while reading a CSV file in Python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related