python - Custom format ID mapping -


i have 2 databases (txt files). 1 two-column, tab-delimited one, holds names , ids.

name1 \t id1 name1 \t id2 name2 \t id9 name2 \t id40 name3 \t id3

the other database has same ids first 1 in first column, while second column lists ids of same kind delimited commas (these children of ones in first one, second database hierarchical).

id1 \t id1,id2,id3 id2 \t id2, id9

what third database same format second, in second column i'd swap out children ids names of first database. example:

id1 \t name1,name2,name3 id2 \t name1,name2

is there way this? i'm quite beginner, when had map ids before used web services, custom format needed further analysis , i'm not sure start.

thanks in advance!

import csv  # reading first db simple since there's fixed delimiter # use csv module split lines , create dictionary maps id name  id_dictionary = {} open('db_1.txt', 'r') infile:     reader = csv.reader(infile, delimiter='\t')     line in reader:         id_dictionary[line[1]] = line[0]  # can again split on tab return 'name1,name2' etc single  # string call split() on later.  row_data = [] open('db_2.txt', 'r') infile:     reader = csv.reader(infile, delimiter='\t')     line in reader:         # id remains unchanged, keep first value         row = [line[0]]          # split string individual elements in list         id_codes = line[1].split(',')          # list comprehension id in dictionary , return         # name stored against         translated = [id_dictionary.get(item) item in id_codes]          # add translated list using represent row         row.extend(translated)          # append row our collection of rows         row_data.append(row)  open('db_3.txt', 'w') outfile:     row in row_data:         outfile.write(row[0])         outfile.write('\t')         outfile.write(','.join(map(str,row[1:]))) # join values comma         outfile.write('\n')

Comments

Post a Comment

Popular posts from this blog

jOOQ update returning clause with Oracle -

according http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/update-statement/ jooq doesn't support returning clause in update statements databases except firebird , postgres. does know, still correct oracle jooq? according oracle's documentation, oracle db supports returning clase delete, insert, or update statements. incorrect manual you're right - manual wrong , should fixed: https://github.com/jooq/jooq/issues/5470 single row update returning jooq 3.8 added support single row update .. returning statements. internally, uses callablestatement , pl/sql block of form: begin update "my_table" set "my_table"."column" = 'xyz' "my_table"."id" = 1 returning "my_table"."id", "my_table"."column" ?, ?; ? := sql%rowcount; end; the relevant issue is: https://github.com/jooq/jooq/issues/5190 multi row update returning a...
Read more

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

i have entity inherits other. on other hand, i'm using lombok project reduce boilerplate code, put @data annotation. annotation @data inheritance produces next warning: generating equals/hashcode implementation without call superclass, though class not extend java.lang.object. if intentional, add '@equalsandhashcode(callsuper=false)' type. is advisable add annotation @equalsandhashcode (callsuper = true) or @equalsandhashcode (callsuper = false) ? if not added, 1 callsuper=false or callsuper=true ? the default value false . 1 if don't specify , ignore warning. yes, recommended add @equalsandhashcode annotation on @data annotated classes extend else object. cannot tell if need true or false , depends on class hierarchy, , need examined on case-by-case basis. however, project or package, can configure in lombok.config call super methods if not direct subclass of object. lombok.equalsandhashcode.callsuper = call for configuration system ...
Read more

java - BasicPathUsageException: Cannot join to attribute of basic type -

i using java 8 jpa (hibernate 5.2.1). have clause works perfectly, until introduce clause make use foreign key table values too. i getting following error: basicpathusageexception: cannot join attribute of basic type i think problem related fact have join table, , not sure how create join using join table. employee - employee_category - category model (employee.java): @manytomany(cascade = cascadetype.all, fetch=fetchtype.eager) @jointable ( name="employee_category", joincolumns={ @joincolumn(name="emp_id", referencedcolumnname="id") }, inversejoincolumns={ @joincolumn(name="cat_id", referencedcolumnname="id") } ) private set<category> categories; model (category.java): @id private string id; jpa when introduce following code, fails error above (i think problem new piece of code): join<t, category> category = from.join("id"); predicates.add(criteriabuilder.like(category....
Read more