[Tutor] Suggestions Please
Dave Angel
davea at davea.name
Tue Oct 7 04:03:12 CEST 2014
Phillip Pugh <pughpl at me.com> Wrote in message:
> I am trying to decide if Python is the right toolset for me. I do a lot of data analytics. Over the years I have used a lot of SQL and VBA, but the data sources are getting bigger. I am thinking Python may be what I need to use, but I am in the early stages of getting to know Python. Can you point me to a really good, intuitive resource for getting up to speed with data. Something that would help with the following.
>
> I have one text file that is 500,000 + records.. I need to read the file, move "structured" data around and then write it to a new file. The txt file has several data elements and is 300 characters per line. I am only interested in the first two fields. The first data element is 19 characters. The second data element is 6 characters. I want to rearrange the data by moving the 6 characters data in front of the 19 characters data and then write the 25 character data to a new file.
>
> I have spent some time digging for the correct resource, However being new to Python and the syntax for the language makes it slow going. I would like to see if I can speed up the learning curve. Hopefully can get some results quickly then I will know how deep I want to go into Python.
>
Open the two files, using the 'with' statement. Using a for loop,
iterate over the input file. For each line, use substring
operators to fetch each field. Then write second + first. Maybe
6 lines.
If you can get most of this, show it to us, and tell us where
you're stuck.
--
DaveA
More information about the Tutor
mailing list