CSV to Excel conversion using Python
<p>I wrote a piece of code that parse a .csv and save the data in excel format.
The problem is that all my data in excel appear as "number stored as text" and i need the data starting with column 3 to be converted as number type so i can represent it using a chart.
My table is looking something like this:</p>

<pre><code>    C1     C2       C3
R1  BlaBla          36552.00233102 ...
R2         App1     3484.000000000 ...
R3         App2     3399.000000000 ...
.....................................
</code></pre>

<p>and this is the code:</p>

<pre><code>f = open("csv_file")
wb = openpyxl.Workbook()
ws = wb.active
reader = csv.reader(f, delimiter=',')
for i in reader:
    ws.append(i)

f.close()
wb.save("excel_file")
</code></pre>

<p>I suggest to use pandas
pandas.read_csv and pandas.to_excel</p>

python excel csv openpyxl