Reading a file name fron a folder on my desktop

[Fiona]

Hello.
Am currently learning python and Robotics,
uhm doing a simple process automation using selenium and python
kindly i need help on how i can read a file name from a folder(folder has several PDF files) on my desktop ,
insert the file name in a search bar on my website and after searching for the filename,
go back to the folder and pick now the exact file ,PDF whose name was read and then upload it on the website,

After the file is uploaded, then the file can be moved to another folder, and the process continues until all file names are picked and respective PDF files uploded.


KR

[Axel_Erfurt]

Show what you tried.

[Fiona]

Show what you tried.

[Fiona]

FullPath = r'path'
FileList=os.listdir(path)
FileList = pd.DataFrame(FileList)
FileList.columns = ['PremisesNo']
FileList['FullPath'] = path+FileList['PremisesNo']
FileList = FileList.reset_index()
for index, row in FileList.iterrows():
Name = FileList.PremiseName.iloc[[index]].values[0]
FullPath = FileList.FullPath.iloc[[index]].values[0]
DateXpath = '/html/body/table/tbody/tr['+str(index+1)+']/td[3]'
Date = driver.find_element(by=By.XPATH, value=DateXpath).text

buran write Aug-20-2023, 04:43 AM:
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.

[Axel_Erfurt]

This is how you can create a dataframe from the file list. (change '/your/path' to your path)

import pandas as pd
import os

full_path = '/your/path'
# create list from files in folder
file_list = os.listdir(full_path)

data = []
for file in sorted(os.listdir(full_path)):
    data.append((f"{full_path}/{file}", file))

df = pd.DataFrame(data, columns=['Full Path', 'File Name'])
print (df)

print(35*"#")

for index, row in df.iterrows():
    name = df['File Name'].iloc[[index]].values[0]
    fullpath = df['Full Path'].iloc[[index]].values[0]
    print(f"Name: {name}\nPath: {fullpath}")