parsing - Split text in text file on the basis of comma and space (python) -

-

i need parse text of text file 2 categories:

  1. university
  2. location(example: lahore, peshawar, jamshoro, faisalabad)

but text file contain following text:

"imperial college of business studies, lahore" "government college university faisalabad" "imperial college of business studies lahore" "university of peshawar, peshawar" "university of sindh, jamshoro" "london school of economics" "lahore school of economics, lahore"

i have written code separate locations on basis of 'comma'. below code work first line of file , prints 'lahore' after give following error 'list index out of range'.

file = open(path,'r') content = file.read().split('\n')  line in content:     rep = line.replace('"','')     loc = rep.split(',')[1]     print "uni: "+replace     print "loc: "+str(loc)

please i'm stuck on this. thanks

it appear can line has location if there comma. make sense parse file in 2 passes. first pass can build set holding known locations. can start off known examples or problem cases.

pass 2 use comma match known locations if there no comma, line split set of words. intersection of these location set should give location. if there no intersection flagged "unknown".

locations = set(["london", "faisalabad"])  open(path, 'r') f_input:     unknown = 0     # pass 1, build set of locations     line in f_input:         line = line.strip(' ,"\n')         if ',' in line:             loc = line.rsplit("," ,1)[1].strip()             locations.add(loc)      # pass 2, try , find location in line     f_input.seek(0)      line in f_input:         line = line.strip(' "\n')         if ',' in line:             uni, loc = line.rsplit("," ,1)             loc = loc.strip()         else:             uni = line             loc_matches = set(re.findall(r"\b(\w+)\b", line)).intersection(locations)              if loc_matches:                 loc = list(loc_matches)[0]             else:                 loc = "<unknown location>"                 unknown += 1          uni = uni.strip()          print "uni:", uni         print "loc:", loc      print "unknown locations:", unknown

output be:

uni: imperial college of business studies loc: lahore uni: government college university faisalabad loc: faisalabad uni: imperial college of business studies lahore loc: lahore uni: university of peshawar loc: peshawar uni: university of sindh loc: jamshoro uni: london school of economics loc: london uni: lahore school of economics loc: lahore unknown locations: 0

Comments

Post a Comment

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

-
i'm trying apply flex button on firefox i'm having problem on chrome doesn't happens. this css: .button { display: inline-flex; align-items: center; } as can see in fiddle, "caret" word moved new line, happens if element <button> tag, <div> works expected. http://codepen.io/anon/pen/xblmgx is firefox bug or there css i'm missing? nevermind, looks "mr firefox" doesn't idea... <button> not implementable (by browsers) in pure css, bit of black box, perspective of css. means don't react in same way e.g. <div> would. this isn't specific flexbox -- e.g. don't render scrollbars if put "overflow:scroll" on button, , don't render table if put "display:table" on it. stepping further, isn't specific <button> . consider <fieldset> , <table> have special rendering behavior: data:text/html,<fieldset style="d
Read more

html - Missing border-right in select on Firefox -

-
Image
when put select div width , padding-left, options have no border on right. more, happend if select have width 118px , parent have 15px of padding left! have idea, going on? my code: <!doctype html> <html> <head lang="en"> </head> <body> <div style="width: 1000px; padding-left: 15px;"> <select style="width: 118px;"> <option>a</option> <option>b</option> <option>c</option> </select> </div> </body> </html> and result: here plunker: click it happend on firefox on windows. tested on 40.0.2 version -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; box-sizing: border-box; source: https://stackoverflow.com/a/11390432/4431269 source of problem: https://bugzilla.mozilla.org/show_bug.cgi?id=924068 and use of google ! edit: (source of problem, explained) after rea
Read more

c# - two queries in same method -

-
i trying execute 2 queries in same method gives me exception. can red of exception declaring new command there way use same command? string id="hi"; connection.open(); oledbcommand command1 = new oledbcommand(); command1.connection = connection; string query1 = "select * products category='" + combobox1.text + "' , subcategory = '" + combobox2.text + "' , sizes='" + combobox3.text + "'"; command1.commandtext = query1; oledbdatareader reader = command1.executereader(); while (reader.read()) { id = reader[0].tostring(); } textbox1.text = id; string query = "insert category_in (category_id,amount,amount_in) values ('"+ id+"' ,500,300)"; command1.commandtext = query; command1.executenonquery(); messagebox.show("saved"); connection.close();
Read more