nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create Path with OS dirname

kapalczynski

I can hardcode this with no issues

CSV_FILE = r"C:\\Users\\cccc\\Desktop\\~GIS_projects\\aaaStagingProcessingScripts_dev_tst\\AGOL_User_Expire_Email\\AGOL_Users_ToExpire\\UsersAboutToExpire.csv"

df_new = pd.read_csv(CSV_FILE)

I want to grab the Location OA path with this

osPath = os.path.dirname(os.path.abspath(__file__))

CSV_FILE = osPath + r"\\AGOL_Users_ToExpire\\UsersAboutToExpire.csv"

df_new = pd.read_csv(CSV_FILE)

BUT the layer does not work... any thoughts? Seems like a syntax issue but cant figure it out

Encontre mais publicações marcadas com

Accepted answers

CodyPatterson

Hey @kapalczynski

You may want to place some debugging messages in the code to ensure that it's going to exactly what you want, try this out:

osPath = os.path.dirname(os.path.abspath(__file__))
CSV_FILE = os.path.join(osPath, "AGOL_Users_ToExpire", "UsersAboutToExpire.csv")
print(CSV_FILE)  # Debug using this print on the csv file
df_new = pd.read_csv(CSV_FILE)

There may also be an issue with your concatenation, try this out as well:

CSV_FILE = os.path.join(osPath, "AGOL_Users_ToExpire", "UsersAboutToExpire.csv")

Along those lines, could you send the error that's appearing when you try to run this?

Cody

All comments

TylerT

In addition to @CodyPatterson 's recommendation you could move on to Pythons object oriented path library called Pathlib. I have found Pathlib more readable and robust. Your code would look something like this:

from pathlib import Path
import pandas as pd

os_path = Path(__file__).resolve().parent
csv_file = os_path / "AGOL_Users_ToExpire" / "UsersAboutToExpire.csv"
df_new = pd.read_csv(csv_file)

Tyler

ArniMiller

1//

CodyPatterson

Hey @kapalczynski

You may want to place some debugging messages in the code to ensure that it's going to exactly what you want, try this out:

osPath = os.path.dirname(os.path.abspath(__file__))
CSV_FILE = os.path.join(osPath, "AGOL_Users_ToExpire", "UsersAboutToExpire.csv")
print(CSV_FILE)  # Debug using this print on the csv file
df_new = pd.read_csv(CSV_FILE)

There may also be an issue with your concatenation, try this out as well:

CSV_FILE = os.path.join(osPath, "AGOL_Users_ToExpire", "UsersAboutToExpire.csv")

Along those lines, could you send the error that's appearing when you try to run this?

Cody

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.