Home > Net >  pandas to.csv method doubles all '\'
pandas to.csv method doubles all '\'

Time:03-15

so i am trying to save a dataframe to csv using the pandas library for some reason the to_csv pandas method is changing the directory i am referring to... i broke the code down as much as i can in order to simplify where everything is coming from and still cant find the problem. thanks in advance!!

A = ['1', '2', '3', '4', '5']
B = ['one', 'two', 'three', 'four', 'five']

df = percentile_list = pd.DataFrame(
    {'lst1Title': A,
     'lst2Title': B})
print(df)
ticker_name = "AAPL"
path = r'C:\Users\my_name\Documents\python projects\my_project\\'   ticker_name   '_stock-price.csv'
print(path)
df.to_csv(path)

it shows that the next link does not exist... C:\Users\my_name\Documents\python projects\my_project\AAPL_stock-price.csv why did it double the '' every where? beyond that pycharm marks the "path" string in the to_csv line and says "Expected type 'None', got 'str' instead " while i know that the to_csv method can handle strings... any one?

CodePudding user response:

The functionality of it adding a backslashes to your path is normal as it is resolving the path and is returning an escaped string.

Just adjust your path variable like so and try again:

path = fr'C:\Users\my_name\Documents\python projects\my_project\{ticker_name}_stock-price.csv'

CodePudding user response:

Consider the OS agonstic file path concatenation to avoid path separator issues where every subfolder is specified in comma-separated elements with base file at the end.

import os

...
path = os.path.join(
    "C:", "Users", "my_name", "Documents", "python projects", 
    "my_project",  "f{ticker_name}_stock-price.csv"
)
  • Related