Python Forum

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

Show what you tried.

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

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}")