Python Forum
Reading a file name fron a folder on my desktop
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Reading a file name fron a folder on my desktop
#5
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}")
Reply


Messages In This Thread
RE: Reading a file name fron a folder on my desktop - by Axel_Erfurt - Aug-23-2023, 11:11 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Compare folder A and subfolder B and display files that are in folder A but not in su Melcu54 3 612 Jan-05-2024, 05:16 PM
Last Post: Pedroski55
Sad problems with reading csv file. MassiJames 3 702 Nov-16-2023, 03:41 PM
Last Post: snippsat
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,151 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Reading a file JonWayn 3 1,130 Dec-30-2022, 10:18 AM
Last Post: ibreeden
  Reading Specific Rows In a CSV File finndude 3 1,019 Dec-13-2022, 03:19 PM
Last Post: finndude
  Excel file reading problem max70990 1 917 Dec-11-2022, 07:00 PM
Last Post: deanhystad
  Replace columns indexes reading a XSLX file Larry1888 2 1,012 Nov-18-2022, 10:16 PM
Last Post: Pedroski55
  Function not executing each file in folder mathew_31 9 2,343 Aug-22-2022, 08:40 PM
Last Post: deanhystad
  Failing reading a file and cannot exit it... tester_V 8 1,861 Aug-19-2022, 10:27 PM
Last Post: tester_V
  Reading .csv file doug2019 4 1,737 Apr-29-2022, 09:55 PM
Last Post: deanhystad

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020