writing data in csv format code example
Example 1: python save as csv
import numpy as np
np.savetxt('data.csv', (col1_array, col2_array, col3_array), delimiter=',')
Example 2: Write a table to CSV file python
header = [re.sub(' +',' ',i[0][:-1].replace('\n', ' ')) for i in optionsTable[0]]
with open('test.csv', 'w') as fp:
writer = csv.writer(fp, delimiter=',')
writer.writerow(header)
for row in optionsTable:
writer.writerow([i[1] for i in row])
#Credit to https://stackoverflow.com/users/790387/burhan-khalid Burhan Khalid
#On StackOverflow.