Read CSV With Different Separator Into Pandas

Python

In order to change what Pandas uses as a separator when reading a csv into a dataframe then use the sep parameter.

In the example below we are importing a csv with the separator set to be a forward slash rather the default comma.

 1|  import pandas as pd
 2|  
 3|  df = pd.read_csv('sales_data.csv', sep='/')
detro
Read_csv
Did you find this snippet useful?

Sign up for free to to add this to your code library

Remove Stop Words from Text in DataFrame Column
Python

Pandas | Nltk | Nlp

150
LightGBM Custom Loss Function
Python

LightGBM | Loss function

133
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

128
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

120
How to Scale Data Using Standard Scaler But Keep Column Names
Python

Scaler | Standard

93
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

91
Calculating Root Mean Squared Error (RMSE) with Sklearn and Python
Python

Rmse

87
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

69
How to Train a Catboost Classifier with GridSearch Hyperparameter Tuning
Python

Catboost | Hyperparameter tuning

68
Overwriting a Python Logging File Instead of Appending
Python

Logging

66