Databases
StackOverflow2013
Postsdbo
POParsing CSV / tab-delimited txt file with Python
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POParsing CSV / tab-delimited txt file with Python
    primarykey
    data
    text
    <p>I currently have a CSV file which, when opened in Excel, has a total of 5 columns. Only columns A and C are of any significance to me and the data in the remaining columns is irrelevant.</p> <p>Starting on line 8 and then working in multiples of 7 (ie. lines 8, 15, 22, 29, 36 etc...), I am looking to create a dictionary with Python 2.7 with the information from these fields. The data in column A will be the key (a 6-digit integer) and the data in column C being the respective value for the key. I've tried to highlight this below but the formatting isn't the best:-</p> <pre><code> A B C D 1 CDCDCDCD 2 VDDBDDB 3 4 5 6 7 DDEFEEF FEFEFEFE 8 123456 JONES 9 10 11 12 13 14 15 293849 SMITH </code></pre> <p>As per the above, I am looking to extract the value from A7 (DDEFEEF) as a key in my dictionary and "FEFEFEFE" being the respective data and then add another entry to my dictionary, jumping to line 15 with "2938495" being my key and "Smith" being the respective value.</p> <p>Any suggestions? The source file is a .txt file with entries being tab-delimited. Thanks</p> <p>Clarification:</p> <p>Just to clarify, so far, I have tried the below:-</p> <pre><code>import csv mydict = {:} f = open("myfile", 'rt') reader = csv.reader(f) for row in reader: print row </code></pre> <p>The above simply prints out all content though a row at a time. I did try "for row(7) in reader" but this returned an error. I then researched it and had a go at the below but it didn't work neither:</p> <pre><code>import csv from itertools import islice entries = csv.reader(open("myfile", 'rb')) mydict = {'key' : 'value'} for i in xrange(6): mydict['i(0)] = 'I(2) # integers representing columns range = islice(entries,6) for entry in range: mydict[entries(0) = entries(2)] # integers representing columns </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USthefragileomen
    1. USthefragileomen
    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. VO
      singulars
      1. POParsing CSV / tab-delimited txt file with Python
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POParsing CSV / tab-delimited txt file with Python
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POParsing CSV / tab-delimited txt file with Python
      1. USserk
      1. VTFavorite
    1. CO@jdigital - original question edited to contain what I've tried so far
      singulars
      1. POParsing CSV / tab-delimited txt file with Python
      1. USthefragileomen
    2. CO"starting on line 8" is not consistent with "A7", "6-digit integer" is not consistent with "DDEFEEF" -- please edit your question.
      singulars
      1. POParsing CSV / tab-delimited txt file with Python
      1. USJohn Machin
    3. CO@John Machin - A7 is not the cell I want to extract the data from, it is A8. The data in A7 is simply just to give you an example of what other data exists in my CSV file. As it's not a 6-digit integer, it is to be ignored. Thanks
      singulars
      1. POParsing CSV / tab-delimited txt file with Python
      1. USthefragileomen
 

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