Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think this is close to what you're looking for -- it's what I meant about putting the <code>if</code>statements from the two scripts inside a single<code>for</code>loop. It could be optimized, but I've tried to keep it simple so you can easily understand what is being done.</p> <pre><code>with open("inputcsv1.csv", "rt") as input_file: header = input_file.readline()[:-1] # remove trailing newline # add a title to the header for each of the two new columns header += ",Table exists?,Are you sure table exists?" output_lines = [header] for line in input_file: line = line[:-1] # remove trailing newline cols = line.split(',') # split line in columns based on delimiter # add first column if 'table' in cols[3]: line += ",table exists" else: line += ",No table found" # add second column if 'table' in cols[3]: line += ",table definitely exists" else: line += ",No table was not found" output_lines.append(line) with open("TestMurgedOutput.csv", "wt") as output_file: output_file.write("\n".join(output_lines)) </code></pre> <p>Contents of the <code>TestMurgedOutput.csv</code> file created:</p> <pre class="lang-none prettyprint-override"><code>title1,title2,title3,Table or no table?,title4,Table exists?,Are you sure table exists? data,text,data,the cat sits on the table,text,data,table exists,table definitely exists data,text,data,tables are made of wood,text,data,table exists,table definitely exists data,text,data,the cat sits on the television,text,data,No table found,No table was not found data,text,data,the dog chewed the table leg,text,data,table exists,table definitely exists data,text,data,random string of words,text,data,No table found,No table was not found data,text,data,table seats 25 people,text,data,table exists,table definitely exists data,text,data,I have no idea why I made this example about tables,text,data,table exists,table definitely exists data,text,data,,text,data,No table found,No table was not found </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POConsolidating two scripts into one new one (appending columns to csv)
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USmartineau
    1. USmartineau
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POConsolidating two scripts into one new one (appending columns to csv)
      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 tried something very similar to this, before I posted earlier but thought I must be too far off the mark. It seems too simple. Will test it now :) Thanks for the answer :)
      singulars
      1. PO
      1. USGTPE
    2. COOne optimization I left out was that since the two `if`s seem to be checking the same condition, there really only needs to be one of them (and corresponding `else`) which does the combined result of what being done in two steps.
      singulars
      1. PO
      1. USmartineau
    3. CONo thats fine Martineau, my real scripts have about 30 different if statements for each column, providing lots of different outputs. As I mentioned to the other answer below that is a fault of mine by providing an over simplified example :)
      singulars
      1. PO
      1. USGTPE
 

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