8 examples of 'python write list to csv column' in Python

137
def save_list_to_csv(list, filename):
138
    f = open(filename, 'w')
139
    writer = csv.writer(f, lineterminator='\n')
140
    writer.writerows(list)
141
    f.close()

305
def to_csv(self, f):
306
    is_path = False
307
    if isinstance(f, str):
308
        is_path = True
309
        f = open(f, mode='w')
310
    writer = csv.DictWriter(f, self.columns)
311
    writer.writerows(self._data)
312
    if is_path:
313
        f.close()

75
def writecsv(filename, rows, separator="\t", encoding="utf-8-sig"):
76
    """Write the rows to the file.
77
78
    :param filename: (str)
79
    :param rows: (list)
80
    :param separator: (str):
81
    :param encoding: (str):
82
83
    """
84
    with codecs.open(filename, "w+", encoding) as f:
85
        for row in rows:
86
            tmp = []
87
            for s in row:
88
                if isinstance(s, (float, int)):
89
                    s = str(s)
90
                else:
91
                    s = '"%s"' % s
92
                tmp.append(s)
93
            f.write('%s\n' % separator.join(tmp))

67
def write_csv(writer, data):
68
    writer.writerow(data)

90
def write_rows_to_csv(row_list, filename):
91
    """
92
    Write a list of namedtuple objects to a (unicode) CSV file.
93
    
94
    Args:
95
     row_list A list of namedtuple objects
96
    Returns:
97
    Raises:
98
    """
99
    with open(filename,'w') as out_file:
100
        csv_file = UnicodeWriter(out_file, quoting=csv.QUOTE_ALL)
101
        write_header = True
102
        for row in row_list:
103
            if write_header:
104
                write_header = False
105
                csv_file.writerow(list(row._fields))
106
            csv_file.writerow([x for x in row._asdict().itervalues()])

20
def ToCsv(self,name='FileName.csv', DataToWrite=[
21
    ["First", "Second", "Third"], ]):
22
    #Write DataResult to CSV file
23
    with open(name, 'w', newline='') as fp:
24
        a = csv.writer(fp, delimiter=',')
25
        a.writerows(DataToWrite)

51
def write(self, propnames, separator=','):
52
    res = ''
53
    nbprop = len(propnames)
54
    for i, prop in enumerate(propnames):
55
        if hasattr(self, prop):
56
            v = self.__dict__[prop]
57
            if type(v) == str:
58
                res += '"'+v+'"'
59
            else:
60
                res += str(v)
61
        if i < nbprop-1:
62
            res += separator
63
    return res

66
def write_row_per_record(csv_writer, collection):
67
    for record in collection:
68
        csv_writer.writerow(get_values_dict(record, object_dict.values()))