Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Note that this solution doesn't rely on the lengths of any field except for the length of the file extension in the second file.</p> <pre><code># make a dict keyed on the filename before the extension # with the other two fields as its value file2dict = dict((row[0][:-4], row[1:]) for row in (line.split() for line in file2)) # then add to the end of each row # the values to it's first column output = [row + file2dict[row[0]] for row in (line.split() for line in file1)] </code></pre> <p>For testing purposes only, I used:</p> <pre><code># I just use this to emulate a file object, as iterating over it yields lines # just use file1 = open(whatever_the_filename_is_for_this_data) # and the rest of the program is the same file1 = """12319000 -64,7357668067227 -0,1111052148685535 12319000 -79,68527661064425 -0,13231739777754026 12319000 -94,69642857142858 -0,15117839559513543 12319000 -109,59301470588237 -0,18277783185642743 12319001 99,70264355742297 0,48329515727315125 12319001 84,61113445378152 0,4060446341409862 12319001 69,7032037815126 0,29803063228455073 12319001 54,93886554621849 0,20958105041136763 12319001 39,937394957983194 0,13623056582981297 12319001 25,05574229691877 0,07748669438398018 12319001 9,99716386554622 0,028110643107892755""".splitlines() # again, use file2 = open(whatever_the_filename_is_for_this_data) # and the rest of the program will work the same file2 = """12319000.abf mutant 1 12319001.abf mutant 2 12319002.abf mutant 3""".splitlines() </code></pre> <p>where you should just use normal file objects. The output for the test data is :</p> <pre><code> [['12319000', '-64,7357668067227', '-0,1111052148685535', 'mutant', '1'], ['12319000', '-79,68527661064425', '-0,13231739777754026', 'mutant', '1'], ['12319000', '-94,69642857142858', '-0,15117839559513543', 'mutant', '1'], ['12319000', '-109,59301470588237', '-0,18277783185642743', 'mutant', '1'], ['12319001', '99,70264355742297', '0,48329515727315125', 'mutant', '2'], ['12319001', '84,61113445378152', '0,4060446341409862', 'mutant', '2'], ['12319001', '69,7032037815126', '0,29803063228455073', 'mutant', '2'], ['12319001', '54,93886554621849', '0,20958105041136763', 'mutant', '2'], ['12319001', '39,937394957983194', '0,13623056582981297', 'mutant', '2'], ['12319001', '25,05574229691877', '0,07748669438398018', 'mutant', '2'], ['12319001', '9,99716386554622', '0,028110643107892755', 'mutant', '2']] </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to combine lines in two files with condition in python?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USagf
    1. USagf
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to combine lines in two files with condition in python?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI don't fully understand, how this should work with the hole files? I should modify the first part as file1 = file1_old.splitlines() file2 = file2_old.splitlines() and then execute the second part?
      singulars
      1. PO
      1. USPhlya
    2. CO@Ilya I added a couple of more comments, but basically just use `fileX = open(filename)` instead of what I have for the file.
      singulars
      1. PO
      1. USagf
    3. COThank you! Gonna try it now.
      singulars
      1. PO
      1. USPhlya
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload