Where should I start

Question

ok, so some software I use for my work presents data in a nice spreadsheet, but the reports it exports to my clients is in some awful way to long html file. I can save it as a csv. so what I'm wondering is if someone could nudge me in the right direction (I don't want it written for me) so I can use a python script to automatically edit the csv, and export it to a spreadsheet format so my clients have an easy to read report.

Answer 1

please see this simple python code ,it may help you think a way about writing reading and using csv format

https://code.sololearn.com/cbM891WJbXEC/?ref=app

Answer 2

in which platform your app works ? if windows ı suggest c# ... So you can use office's libraries and also datasets / ole and many things will help your users

Answer 3

I suggest Csharp

Answer 4

thanks! I'll look into it, this is going to be my first usable project so I'm excited to get started

Answer 5

it's a great feeling when it works. My first usable Python project was a script to sort 5,000+ Rom files down the the 1600 or so I wanted. a little work and it couldn't have went better.

after that my emulator needed .bin extension on my files, but they had .gen.. Slight alternation of my script and I had 1600 files with the proper extension.

Running your own script to handle your own business is an empowering feeling.

Answer 6

oh also important, the csv that it outputs is really stupid so just opening in calc doesn't work, all the data gets mixed up

Answer 7

it is windows, I was just hoping to use the language I'm already learning instead of having to learn another one at the same time, I want to master one before moving on, just to avoid confusion for myself

Answer 8

Python can handle this, it is very good at these type of things. basically what your saying is you have something like

name,job,other,random,info

and you want to be able to change a single piece?

Answer 9

to be specific I'm an SEO guy, and I need to take a CSV comprised of his keywords, his pages and and all of his competitions rank for the same keywords and put it into a readable spreadsheet

Answer 10

This might be just what you need.

https://dzone.com/articles/JUMP_LINK__&&__python__&&__JUMP_LINK-101-reading-and-writing

This is all about reading and writing csv files

Answer 11

so I guess really it would need to create a new row every x number of items, maintaining separate cells for each item

Answer 12

Combine it with this and you will be in business

https://docs.python.org/2/library/csv.html

Answer 13

You don't have to create a new row. You can have a giant row if you want, but it is easier to read a new line from a file. If you leave it a single line you would need a special char to use a split() function. It would turn it into a list of lists basically