3 examples of 'pandas to tsv' in Python

74
def toTSV(dbhandle, outfile, statement, remove_none=True):
75
    '''execute statement and save as tsv file
76
    to disk.
77
78
    If *remove_none* is true, empty/NULL values will be output as
79
    empty values.
80
81
    '''
82
    cc = dbhandle.cursor()
83
    cc.execute(statement)
84
    outfile.write("\t".join([x[0] for x in cc.description]) + "\n")
85
86
    def _str(x):
87
        if x is None:
88
            return ""
89
        else:
90
            return str(x)
91
92
    if remove_none:
93
        f = _str
94
    else:
95
        f = str
96
97
    outfile.write("\n".join(
98
        ["\t".join(map(f, x)) for x in cc]))

57
def _dataframe_to_txt(writer, dataframe):
58
    encoding_writer = codecs.getwriter('utf-8')(writer)
59
    for row in dataframe.iterrows():
60
        encoding_writer.write("".join(row[1].tolist()))
61
        encoding_writer.write('\n')

141
def export_tsv_to_sqlite():
142
    create_sqlite_tables()
143
    conn = open_db()
144
    c = conn.cursor()
145
146
    filename = 'enwiki.features_damaging.20k_2015.tsv'
147
    f = open(filename,'rt')
148
    i = 1
149
    for row in read_tsv(f):
150
        print(i)
151
        i = i + 1
152
        other_features = pickle.dumps(row[1:-1])
153
        c.execute('''INSERT INTO observations
154
        (revid, other_features, is_damaging)
155
        VALUES (?, ?, ?)''', (row[0], other_features, row[-1]))
156
    conn.commit()
157
    conn.close()