Raw Data to CSV python script

Question

I used cloudSim and CloudReports simulators for an experiment and i got my results into a raw data file rawData.CRD. Now I want to convert it to a csv file so that I can import it into RStudio for further analysis.

I followed this script.

import csv
import itertools
with open('rawData.CRD', 'r') as in_file:
    stripped = (line.strip() for line in in_file)
    lines = (line for line in stripped if line)
    grouped = itertools.izip(*[lines] * 3)
    with open('extracted.csv', 'w') as out_file:
        writer = csv.writer(out_file)
        writer.writerow(('title', 'intro', 'tagline'))
        writer.writerows(grouped)

It is creating a .csv file with all single row. But I want each values in seperate cells (when opened in Excel).

This is how my input raw file looks like from the simulator.

and this is what I get after applying the script, all data as single element.

Please Help me to modify the script.

i got the script from the following thread.stackoverflow.com/questions/16248513/… — dvs
– dvs, Commented Oct 5, 2014 at 3:04
No, actually I am developing an app using R. So I need this file as the input for app — dvs
– dvs, Commented Oct 5, 2014 at 4:21

Miss Yu · Accepted Answer · 2014-10-05 04:48:52Z

0

If you want the CSV file to be opened by Excel, then I suggest letting the CSV writer know that through the dialect parameter.

        writer = csv.writer(out_file, dialect=csv.excel)

answered Oct 5, 2014 at 4:48

Miss Yu

412 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 10:32:41Z

0

if you want the data presented like this, change 3 to 1 , without the blank line ,just edit the "w" with "wb" {cr:CSV file written with Python has blank lines between each row) I sill look for other methods to cut the group words into columns.

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Oct 16, 2016 at 19:04

C. Hong

12 bronze badges

Collectives™ on Stack Overflow

Raw Data to CSV python script

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related