extractskills.py

#YAY! My first Python script!
#sub routine to find the first instance of a skill name (passed) in a file (passed) and write it out
def WriteSkill (skill, filename):
    s=-1 #so I can initialize the variable for later
    with open(filename) as f: #open the passed file name and load it into 'f'
        for line in f: #loop over each line in the file
            mystr=r''+re.escape(skill)+r':\s+(\d+) (\d\d)' #cobble together a regex
            s=re.search(mystr,line) #look for the string on that line and save the digits if you found it
            if s:
                outfile.write(s.group(1)+"."+s.group(2)+",") #write the string out
                break #about the for loop
    if s < 0: #is s still empty? then you didn't find anything, report 0 to the outfile
        outfile.write("0,")
    return

#subroutine that's ugly and just calls all the skill names, I should make this an array, but hey I'm working on it!
def WriteAll (filename):
    outfile.write(re.search(r'(\d{4}-\d{2}-\d{2})',filename).group(1)+",") #write the date in the first cell extracted from the file name
    WriteSkill("Alchemy", filename)
    WriteSkill("Appraisal", filename)
    WriteSkill("Arcana", filename)
    WriteSkill("Athletics", filename)
    WriteSkill("Attunement", filename)
    WriteSkill("Augmentation", filename)
    WriteSkill("Bow", filename)
    WriteSkill("Brawling", filename)
    WriteSkill("Brigandine", filename)
    WriteSkill("Chain Armor", filename)
    WriteSkill("Crossbow", filename)
    WriteSkill("Debilitation", filename)
    WriteSkill("Defending", filename)
    WriteSkill("Enchanting", filename)
    WriteSkill("Engineering", filename)
    WriteSkill("Evasion", filename)
    WriteSkill("First Aid", filename)
    WriteSkill("Forging", filename)
    WriteSkill("Heavy Thrown", filename)
    WriteSkill("Large Blunt", filename)
    WriteSkill("Large Edged", filename)
    WriteSkill("Life Magic", filename)
    WriteSkill("Light Armor", filename)
    WriteSkill("Light Thrown", filename)
    WriteSkill("Locksmithing", filename)
    WriteSkill("Mechanical Lore", filename)
    WriteSkill("Melee Mastery", filename)
    WriteSkill("Missile Mastery", filename)
    WriteSkill("Offhand Weapon", filename)
    WriteSkill("Outdoorsmanship", filename)
    WriteSkill("Outfitting", filename)
    WriteSkill("Parry Ability", filename)
    WriteSkill("Perception", filename)
    WriteSkill("Performance", filename)
    WriteSkill("Plate Armor", filename)
    WriteSkill("Polearms", filename)
    WriteSkill("Scholarship", filename)
    WriteSkill("Scouting", filename)
    WriteSkill("Shield Usage", filename)
    WriteSkill("Skinning", filename)
    WriteSkill("Slings", filename)
    WriteSkill("Small Blunt", filename)
    WriteSkill("Small Edged", filename)
    WriteSkill("Sorcery", filename)
    WriteSkill("Staves", filename)
    WriteSkill("Stealth", filename)
    WriteSkill("Tactics", filename)
    WriteSkill("Targeted Magic", filename)
    WriteSkill("Thievery", filename)
    WriteSkill("Twohanded Blunt", filename)
    WriteSkill("Twohanded Edged", filename)
    WriteSkill("Utility", filename)
    WriteSkill("Warding", filename)
    outfile.write("\n") #put a return at the end of that row
    return

import re #load regex (or so the internet tells me)
outfile = open("output.csv","a") #open the output file for appending
WriteAll("Hanryu-DR-2016-12-25.txt") #file to scan, must be in same folder as script
close("output.csv") #ya done!