Saving a DataFrame to CSV to a Specific Location

Python

In this example we save a Pandas dataframe to csv from a script located in path project_folder/src to path project_folder/data. We use os.path to get the path of the folder two levels above the script and join this to the destination folder and filename where we want to store our csv.

 1|  import os.path as path
 2|  import pandas as pd
 3|  
 4|  train_path = path.abspath(path.join(__file__ ,'../..','data/train.csv'))
 5|  train.to_csv(train_path,index=False)
analyseup
Pandas | Csv | To_csv | Output
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

149
LightGBM Custom Loss Function
Python

LightGBM | Loss function

132
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

127
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

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

Scaler | Standard

92
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

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

Rmse

86
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

68
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

65