How to use variable name within dataframe path

Question

The only thing I added was the attempted concatenation of the file path.

I am getting an 'unexpected character after line continuation character, and cannot figure out why.

import numpy as np
import pandas as pd
import getpass

user = getpass.getuser()

data = pd.read_excel (r'C:\Users\' + user + '\Desktop\bulk export.xlsx',
                       sheet_name=1,
                       header=0)
df = pd.DataFrame(data, 
                  columns= [1,'Record Type'])
print (df)

escape character: r'C:\Users\\', same for the other part as well. — Quang Hoang
– Quang Hoang, Commented Oct 29, 2021 at 14:32
Try f-strings too: pd.read_excel(rf'C:\Users\{user}\Desktop\bulk export.xlsx', sheet_name=1, header=0) — Chris Adams
– Chris Adams, Commented Oct 29, 2021 at 14:38

j__carlson · Accepted Answer · 2021-10-29 16:05:27Z

1

You can try this:

import pathlib
from pathlib import Path

user = getpass.getuser()
my_file = Path(f"C:\\Users\\{user}\\Desktop\\bulk export.xlsx")

data = pd.read_excel (my_file, sheet_name=1, header=0)

edited Oct 29, 2021 at 16:05

answered Oct 29, 2021 at 15:59

j__carlson

1,3583 gold badges14 silver badges22 bronze badges

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

2 Comments

ah2Bwise Over a year ago

why does this work without the 'r' in the front of the path name?

j__carlson Over a year ago

@anarchocaps, r in front of the path makes it a raw string meaning that the \ is treated as literal. In this case \ is also an escape character meaning "\\" is literal "\". You can see this by trying print("\\").

Collectives™ on Stack Overflow

How to use variable name within dataframe path

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related