How to extract the file name from a file path? [duplicate]

Question

I have the following code:

os.listdir("staging") # Seperate filename from extension sep = os.sep # Change the casing for n in os.listdir("staging"): print(n) if os.path.isfile("staging" + sep + n): filename_one, extension = os.path.splitext(n) os.rename("staging" + sep + n, "staging" + sep + filename_one.lower() + extension) # Show the new file names print ('\n--------------------------------\n') for n in os.listdir("staging"): print (n) # Remove the blanks, -, %, and / for n in os.listdir("staging"): print (n) if os.path.isfile("staging" + sep + n): filename_zero, extension = os.path.splitext(n) os.rename("staging" + sep + n , "staging" + sep + filename_zero.replace(' ','_').replace('-','_').replace('%','pct').replace('/','_') + extension) # Show the new file names print ('\n--------------------------------\n') for n in os.listdir("staging"): print (n) """ In order to fix all of the column headers and to solve the encoding issues and remove nulls, first read in all of the CSV's to python as dataframes, then make changes and rewrite the old files """ import os import glob import pandas as pd files = glob.glob(os.path.join("staging" + "/*.csv")) print(files) # Create an empty dictionary to hold the dataframes from csvs dict_ = {} # Write the files into the dictionary for file in files: dict_[file] = pd.read_csv(file, header = 0, dtype = str, encoding = 'cp1252').fillna('')

In the dictionary, the dataframes are named as "folder/name(csv)" what I would like to do is remove the prefix "staging/" from the keys in the dictionary.

How can I do this?

cs95 · Accepted Answer · 2019-01-20 07:08:49Z

If all you want to do is truncate the file paths to just the filename, you can use os.path.basename:

for file in files: fname = os.path.basename(file) dict_[fname] = (pd.read_csv(file, header=0, dtype=str, encoding='cp1252') .fillna(''))

Example:

os.path.basename('Desktop/test.txt') # 'test.txt'

basil_man · Accepted Answer · 2023-05-15 12:41:46Z

In the same spirt as truncate the file paths, use pathlib in python standard library. It will turn the path into an easy to use class.

from pathlib import Path path = Path('Desktop/folder/test.txt') path.name # test.txt path.stem # test path.suffix # .txt path.parent.name # folder path.parent.parent.name # Desktop

Justin Malinchak · Accepted Answer · 2018-06-26 13:53:28Z

import os pathname ='c:\\hello\\dickins\\myfile.py' head, tail = os.path.split(pathname) print head print tail

Santhosh · Accepted Answer · 2017-11-27 13:24:48Z

This article here worked out just fine for me

import os inputFilepath = 'path/to/file/foobar.txt' filename_w_ext = os.path.basename(inputFilepath) filename, file_extension = os.path.splitext(filename_w_ext) #filename = foobar #file_extension = .txt path, filename = os.path.split(path/to/file/foobar.txt) # path = path/to/file # filename = foobar.txt

Hope it helps someone searching for this answer

JerryPlayz101 · Accepted Answer · 2017-07-15 00:35:55Z

As ColdSpeed said, you can use "os.path.basename" to truncate a file to its name, but I think what you are refering to is the ability to pycache the data?

For Example here is my Directory:

You see the pycache folder? that initializes it as a module. Then, you can import a file from that module (for example the staging.txt file and operate on it.) I use the IpConfig.txt File from the assets folder level (or should be) and take a line of information out of it.

import pygame as pyg import sys import os import math import ssl import socket as sock import ipaddress as ipad import threading import random print("Modules Installed!") class two: # Find out how to refer to class super construct def main(Display, SecSock, ipadd, clock): # I have code here that has nothing to do with the question... def __init__(): print("Initializing[2]...") # Initialization of Pygame and SSL Socket goes here searchQuery = open("IpConfig.txt", 'r') #Opening the File IpConfig(Which now should open on the top level of the game files) step2 = searchQuery.readlines()# read the file ipadd = step2[6] # This is what you should have or something similar where you reference the line you want to copy or manipulate. main(gameDisplay, SSLSock, ipadd, clock)# Im having issues here myself - (main() is not defined it says) print(ipadd) print("Server Certificate Configuration Enabled...") __init__() # Start up the procedure

thank you for the detailed response however @COLDSPEED got it right, all i needed to do was truncate the file names for insertion into a database
I was just clarifying how you would go about reading that DB.

Collectives™ on Stack Overflow

How to extract the file name from a file path? [duplicate]

5 Answers 5

Comments

Comments

Comments

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

2 Comments

Linked

Related