Databases
StackOverflow2013
Postsdbo
PODictionary Comprehension: How do we build a dictionary with integers as keys and tuples as values?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODictionary Comprehension: How do we build a dictionary with integers as keys and tuples as values?
    primarykey
    data
    text
    <p>I have a list of data and they are formated like this: (have more lines below are just part of them) </p> <pre><code>2 377222 TOYOTA MOTOR CORPORATION TOYOTA PASEO 1994 Y 19941226 N 0 0 PARKING BRAKE:CONVENTIONAL SAN JOSE CA JT2EL45U5R0 19950103 19950103 1 PARKED ON FLAT SURFACE EMERGENCY BRAKING ENGAGED VEHICLE ROLLED REARWARD. TT EVOQ V 1 958164 TOYOTA MOTOR CORPORATION TOYOTA LAND CRUISER 1994 19941223 N 0 0 SERVICE BRAKES, HYDRAULIC:ANTILOCK ARNOLD CA JT3DJ81W8R0 19950103 19950103 ABS SYSTEM FAILURE, AT 20MPH. TT EVOQ V 46 958153 DAIMLERCHRYSLER CORPORATION DODGE CARAVAN 1987 19940901 N 0 0 EQUIPMENT:MECHANICAL:CARRIER/RACK CORBETT OR 2B4FK4130HR 19950103 19950103 1 CABLE ATTACHMENT THAT SECURES THE SPARE TIRE BROKE WHILE DRIVING. TT EVOQ V 98 958178 GENERAL MOTORS CORP. GMC SAFARI 1994 19941223 N 0 0 SERVICE BRAKES, HYDRAULIC:FOUNDATION COMPONENTS MILAN MI 1GDDM19W4RB 19950103 19950103 1 BRAKES FAILED DUE TO BATTERY MALFUNCTIONING WHEN TOO MUCH POWER WAS DRAWN FROM BATTERY FOR RADIO. TT EVOQ V </code></pre> <p>What is the best way to create a dictionary using index(1) the integer as keys and a tuple of any other 2 elements in the sentence as values? The desired output should be like this:</p> <pre><code>function(filename)[2] ('TOTOTA MOTOR CORPORATION','19941226','SAN JOSE','CA') </code></pre> <p>Here is what I have right now and I was trying to put them all into a dictionary first but it wont iterate through he entire list instead it just returns the elements of a single line. What went wrong with my code? or How do I at least accomplish the first step - putting them all in a dictionary?</p> <pre><code>def function(filename): with open filename as FileObject: A=[] for lines in FileObject: B=[line.split("\t")[0]] A+=B C=[line.split("\t")[2]] A=A+B+C D=[line.split("\t")[12]] A=A+B+C+D E={A:(B,C,D)for A in A} return E print function(filename) </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJunuxx
    1. USBray
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    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.

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