Separate directories from a column using python

Question

I am new to Pyhthon, and have been stuck with some work. I have a .csv file, with 7 columns. The first column contains path to certain files, eg:

Name
a/b/c.xyz
m/n/o/p.sad
p/q/r/s/t/u.asas

I need to separate the directories(path) to the files, and owners being 'a', 'm', 'p' for their respective rows. I have imported the .csv file using pandas. I have read that os.path could be of some help. Any suggestions would be much appreciated.Also, the data I'm working on is pretty big, so need to take care about the overhead in executing the script.

Thanks.

do you want to split owners and paths into two columns?

MaxU - stand with Ukraine
– MaxU - stand with Ukraine

2016-04-07 13:23:43 +00:00
Commented Apr 7, 2016 at 13:23 — MaxU - stand with Ukraine
– MaxU - stand with Ukraine, Commented Apr 7, 2016 at 13:23
Yes sir, that is what I intend to do.

sharang kaushik
– sharang kaushik

2016-04-07 13:34:33 +00:00
Commented Apr 7, 2016 at 13:34 — sharang kaushik
– sharang kaushik, Commented Apr 7, 2016 at 13:34

LarsVegas · Accepted Answer · 2016-04-07 12:47:57Z

1

the os module you mentioned knows three different split variants

os.path.split os.path.splitdrive os.path.splitext

If you just want the first part of your string just use <str>.split('/')[0]

>>> 'p/q/r/s/t/u.asas'.split('/')
>>> 'p'

I'd also recommend to use the build-in csv module to read your file. pandas seems like overkill.

Here a good source on how to use the module. I especially like the csv.DictReader class.

answered Apr 7, 2016 at 12:47

LarsVegas

6,88210 gold badges48 silver badges70 bronze badges

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

2 Comments

IanS Over a year ago

os.path.dirname and os.path.basename could also be useful.

sharang kaushik Over a year ago

Thanks for the help :)

galaxyan · Accepted Answer · 2016-04-07 13:04:43Z

if you just want to find the owner and file name, it could be done by split.

import csv

owner,file =[],[]
with open(filePath,'rb') as f:
    reader = csv.reader(f)
    for line in reader:
        owner.append(line.split('/')[0])
        file.append(line.split('/')[-1])

if you need to find the file path and remove the owner, it can be achieved by split and os.path.join

import csv
import os
owner,file =[],[]
with open(filePath,'rb') as f:
    reader = csv.reader(f)
    for line in reader:
        owner.append(line.split('/')[0])
        file.append(os.path.join( *line.split('/')[1:] ))

os.path.join example:

 string = 'p/q/r/s/t/u.asas'
    os.path.join( *string.split('/')[1:] )
    output:
    'q\\r\\s\\t\\u.asas'

MaxU - stand with Ukraine · Accepted Answer · 2016-04-07 13:26:15Z

0

is that what you want?

In [64]: df
Out[64]:
               Name
0         a/b/c.xyz
1       m/n/o/p.sad
2  p/q/r/s/t/u.asas

In [66]: df.Name.str.extract(r'(?P<owner>.)(?P<path>/.*)', expand=True)
Out[66]:
  owner             path
0     a         /b/c.xyz
1     m       /n/o/p.sad
2     p  /q/r/s/t/u.asas

answered Apr 7, 2016 at 13:26

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

Collectives™ on Stack Overflow

Separate directories from a column using python

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related