Find the file name using python

Question

I have a file with the following format in filename.txt file.

h:\abc\abc_Foldhr_1\hhhhhhhhhh8db

h:\abc\abc_Foldhr_1\hhhhhhhhhh8dc

h:\abc\abc_Foldhr_1\hhhhhhhhhh8dx

h:\abc\abc_Foldhr_1\hhhhhhhhhh8du

h:\abc\abc_Foldhr_1\hhhhhhhhhh8d4

h:\abc\abc_Foldhr_1\hhhhhhhhhh8d5

h:\abc\abc_Foldhr_1\hhhhhhhhhh8d6

h:\abc\abc_Foldhr_1\hhhhhhhhhh8d7

h:\abc\abc_Foldhr_1\hhhhhhhhhh8d8

I was able to read it well but unable to store in pandas data frame or the list or dictionary.

import pandas as pd

#data = pd.read_excel ('/home/home/Documents/pythontestfiles/HON-Lib.xlsx')
data = pd.read_table('/home/home/Documents/pythontestfiles/filename.txt', delim_whitespace=True, names=('A'))
df = pd.DataFrame(data, columns= ['A'])
print(df)

and would like to list out the filename only as

hhhhhhhhhh8db

.

.

.

hhhhhhhhhh8d6

hhhhhhhhhh8d7

hhhhhhhhhh8d8

the purpose of storing in any data frame or dictionary is to compare against the excel file result.

Look for split()

DirtyBit
– DirtyBit

2019-04-20 17:48:37 +00:00
Commented Apr 20, 2019 at 17:48 — DirtyBit
– DirtyBit, Commented Apr 20, 2019 at 17:48

DirtyBit · Accepted Answer · 2019-04-20 19:11:36Z

2

Using split():

res = []
with open('filename.txt', 'r') as file:
      content = file.readlines()
      for line in content:
            # print(line.split('\\')[-1])    # to print each name
            res.append(line.split('\\')[-1]) # append the name to the list
print(res)

EDIT:

Elaborating on the answer given, the split() method being applied on the string splits it by the \\, Consider the following example:

s = 'h:\abc\abc_Foldhr_1\hhhhhhhhhh8db'

print(s.split('\\'))

Which gives the output:

['h:\x07bc\x07bc_Foldhr_1', 'hhhhhhhhhh8db']

The [-1] index grabs the last element in it, hence:

print(s.split('\\')[-1])

Would give:

hhhhhhhhhh8db

edited Apr 20, 2019 at 19:11

answered Apr 20, 2019 at 17:51

DirtyBit

16.8k5 gold badges37 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3256224 Over a year ago

i am not sure with -1 usage. Please share more thought.

DirtyBit Over a year ago

@user3256224 the split() function basically splits the string by \\ and create a list of it. [-1] grabs the last element in the list, i.e. hhhhhhhhhh8db

DirtyBit Over a year ago

@user3256224 added an edit with the explanation as well.

Collectives™ on Stack Overflow

Find the file name using python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related