Editing Code Guide (section)

===Create a .csv file from a list of lists===
It was often useful to export data from the database to a .csv file
for later retrieval. There are a few ways to do this. The first
method uses the pandas package:


<code>
1 import pandas as pd

2

3 column_data = [colA, colB, colC]

4 labels = [’A’, ’B’, ’C’]

5

6 df = pd.DataFrame(column_data)

7 df = df.transpose() # Remove this line if you want rows of data

8 df.columns = labels

9 pd.DataFrame.to_csv(df, ’filename.csv’, index = False)
</code>


To achieve the same result with default packages:


<code>
1 labels = [’A’, ’B’]

2 colAdata = [some_data]

3 colBdata = [some_other_data]

4 RowsAsStrings = [ ]

5

6 # Convert data to strings

7 for i in range (0,len (longest_column)):

8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RowsAsStrings.append(str(colAdata[i]) + ’,’ + str(colBdata[i]))

9

10 # Write strings to a file

11 with open (’file.csv’, ’w+’) as file:

12 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;file.writelines(’labels’)

13 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for i in data_text:

14 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;file.writelines(i + ’\n’)
</code>