StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPython: Parsing and grouping filenames in directory
primarykey
Id
14719621
data
AcceptedAnswerId
14719679
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-02-06T00:38:53.627
FavoriteCount
0
LastActivityDate
2013-02-06T00:46:08.503
LastEditDate
LastEditorUserId
0
OwnerUserId
2007836
ParentId
0
PostTypeId
1
Score
1
ViewCount
3379
LastEditorDisplayName
text
Body
I'm pretty new to python, but I have lots of experience with MATLAB & C. What I need to do it parse the filenames of files in a particular directory, separate them into groups according to the fields within the file names, and perform operations within these groups. Specifically, the filenames are: <pre><code>PROJECT-x-SUBJECT-x-SESSION-x-TYPE.extension </code></pre> where that '-x-' has been purposely inserted as the field divider. I need to do operations on every group of files that shares the same PROJECT-x-SUBJECT-x-SESSION component. _______My best attempt follows: ________ I can parse each of the files one at a time by: <pre><code>dirList=os.listdir(directory) for fname in dirList: # kill extension ext = os.path.splitext(fname) # get the 4 fields labels=ext[0].split('-x-') PROJECT_list.append(labels[0]) SUBJECT_list.append(labels[1]) ... </code></pre> ... which reflects this only idea I have had on how to organize this stuff: by creating 4 lists and appending to them for each filename. Then with my 4 (ordered?) lists, I could then call something like: <pre><code>from collections import Counter c=Counter(SESSION_list) list(c) </code></pre> Then at least I have a unique list of SESSION names Suggestions? I could go on, but since I really just need a starting point, I think that this is sufficient. Thanks, guys.
Tags
<python><parsing><directory>
Title
Python: Parsing and grouping filenames in directory
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USFrederick
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POPython: Parsing and grouping filenames in directory
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.