

In [1]:

    
import csv



In [2]:

    
mesa = [
    {'first': 'joe', 'last': 'lutz', 'address': 'aqui'},
    {'first': 'mike', 'address': 'panera', 'last': 'duncan'},
    {'address': 'nashville', 'first': 'travis', 'last': 'cash'},
]



In [3]:

    
mesa









    Out[3]:





[{'address': 'aqui', 'first': 'joe', 'last': 'lutz'},
 {'address': 'panera', 'first': 'mike', 'last': 'duncan'},
 {'address': 'nashville', 'first': 'travis', 'last': 'cash'}]



In [4]:

    
columns = ['last', 'first', 'address']

# excel_tab dialect is not supported on this creaky old version with open('eggs.csv', 'wb') as csvfile: writer = csv.DictWriter( csvfile, columns, restval='', extrasaction='raise', dialect='excel_tab') for row in mesa: writer.writerow(row)



In [5]:

    
with open('eggs.csv', 'wb') as csvfile:
    writer = csv.DictWriter(
        csvfile, columns, restval='', 
        extrasaction='raise', dialect='excel', delimiter='\t')
    for row in mesa:
        writer.writerow(row)



In [6]:

    
!ls -l eggs.csv









    



-rw-rw-r-- 1 doj doj 58 Oct 11 20:04 eggs.csv



In [7]:

    
!cat eggs.csv | tr -d '\r'









    



lutz	joe	aqui
duncan	mike	panera
cash	travis	nashville

Would like to have something like following to output the results of a query. Catherine probably knows the canonical example for such for an Oracle database.



In [ ]:

    
with open('eggs.csv', 'wb') as csvfile:
    writer = csv.DictWriter(
        csvfile, columns, restval='',
        extrasaction='raise', dialect='excel', delimiter='\t')
    query_results = do_query(FOO_QUERY_SQL)  # This is fakey stub.
    for row in query_results:
        writer.writerow(row)



In [ ]:

    
with open('eggs.csv', 'wb') as csvfile:
    writer = csv.DictWriter(
        csvfile, columns, restval='',
        extrasaction='raise', dialect='excel', delimiter='\t')
    for row in do_query(FOO_QUERY_SQL):  # This is a fakey stub.
        writer.writerow(row)



In [ ]:

    
import psycopg2