Python for text manipulating Post: 302933884

Sponsored Content

Top Forums Programming Python for text manipulating Post 302933884 by johankor on Monday 2nd of February 2015 05:32:34 PM

02-02-2015

Registered User

Python for text manipulating

Dear All,

I am trying to write a python code for reading a fixed number of lines from a big file then save those pieces into another file as columns. I think sample file is necessary for understanding:

Sample Input file:

Code:

Epi. dist.(km)=       0.8100E+02
0.7466E-07  0.4942E-07  0.7133E-07  0.6010E-07  0.1123E-06  0.4819E-07  0.9435E-07  0.6491E-07  0.6051E-07  0.5202E-07
0.1647E-06  0.5267E-07  0.5724E-07  0.1031E-06  0.1143E-06  0.4776E-07  0.3594E-06  0.4832E-07  0.7363E-07  0.1009E-06
0.6381E-07  0.6170E-07  0.6429E-07  0.9720E-07  0.4749E-07  0.6851E-07  0.1585E-06  0.8395E-07  0.4581E-07  0.7321E-07


Epi. dist.(km)=       0.8200E+02
0.2102E-06  0.9821E-07  0.6322E-07  0.1665E-06  0.5524E-06  0.6590E-07  0.1916E-06  0.1292E-06  0.1104E-06  0.8035E-06
0.6358E-06  0.4661E-07  0.9605E-07  0.1492E-06  0.1093E-06  0.1931E-05  0.7120E-07  0.9829E-07  0.1230E-05  0.4093E-06
0.1910E-06  0.2032E-06  0.9052E-07  0.5392E-07  0.5534E-06  0.9899E-07  0.1620E-06  0.1220E-06  0.1220E-06  0.3248E-06


Epi. dist.(km)=       0.8300E+02
0.5564E-07  0.8314E-07  0.8364E-07  0.3975E-07  0.4601E-07  0.4936E-07  0.5480E-07  0.1290E-06  0.4882E-07  0.4571E-07
0.1229E-06  0.2128E-06  0.8432E-07  0.9233E-07  0.4091E-07  0.5957E-07  0.7815E-07  0.6687E-07  0.5402E-07  0.6230E-07
0.6264E-07  0.1231E-06  0.6061E-07  0.4451E-07  0.7700E-07  0.3504E-07  0.1151E-06  0.1150E-06  0.5685E-07  0.5579E-07

.
.
.

So there are blocks in the file that starts with "Epi dist", I need to extract those blocks(without Epi.dist line) then save them as columns into another file. There are 20 similar blocks in the file and each block is 135 lines long(excluding Epi.dist line).

Sample output file:

Code:

0.7466E-07 0.2102E-06 0.5564E-07
0.4942E-07 0.9821E-07 0.8314E-07
0.7133E-07 0.6322E-07 0.8364E-07
0.6010E-07 0.1665E-06 0.3975E-07
0.1123E-06 0.5524E-06 0.4601E-07
0.4819E-07 0.6590E-07 0.4936E-07
0.9435E-07 0.1916E-06 0.5480E-07
0.6491E-07 0.1292E-06 0.1290E-06
0.6051E-07 0.1104E-06 0.4882E-07
0.5202E-07 0.8035E-06 0.4571E-07
0.1647E-06 0.6358E-06 0.1229E-06
0.5267E-07 0.4661E-07 0.2128E-06
0.5724E-07 0.9605E-07 0.8432E-07
0.1031E-06 0.1492E-06 0.9233E-07
0.1143E-06 0.1093E-06 0.4091E-07
0.4776E-07 0.1931E-05 0.5957E-07
0.3594E-06 0.7120E-07 0.7815E-07
0.4832E-07 0.9829E-07 0.6687E-07
0.7363E-07 0.1230E-05 0.5402E-07
0.1009E-06 0.4093E-06 0.6230E-07
0.6381E-07 0.1910E-06 0.6264E-07
0.6170E-07 0.2032E-06 0.1231E-06
0.6429E-07 0.9052E-07 0.6061E-07
0.9720E-07 0.5392E-07 0.4451E-07
0.4749E-07 0.5534E-06 0.7700E-07
0.6851E-07 0.9899E-07 0.3504E-07
0.1585E-06 0.1620E-06 0.1151E-06
0.8395E-07 0.1220E-06 0.1150E-06
0.4581E-07 0.1220E-06 0.5685E-07
0.7321E-07 0.3248E-06 0.5579E-07

I hope I did a good job explaining my problem. Could you help me out?

johankor

View Public Profile for johankor

Find all posts by johankor

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Manipulating a text file

hey guys, need ur expert help. m a core banker got stuck in someting techie and cant find a solution have manged to extract a file from oracle apps in a format that looks something like this... REC- A b c d x INV- A b...

2. Shell Programming and Scripting

csh: manipulating text files - please help!

Hi All, I am trying to manipulate a text file in a csh script I am writing. I just started scripting a few months ago and have NO idea how to get this to work. My ultimate goal is to turn a text file that looks like this: 4 ep2d_diff_mddw_20_p2-MOD err 128 128 64 62 52611737 2 ...

3. Shell Programming and Scripting

Find text containing paths and replace with a string in all the python files

I have 100+ python files in a single directory. I need to replace a specific path occurrence with a variable name. Following are the find and the replace strings: Findstring--"projects\\Debugger\\debugger_dp8051_01\\debugger_dp8051_01.cywrk" Replacestring--self.projpath I tried...

4. Programming

Python: Check 2 text files for string and print contexts

I have 2 text files: cities.txt San Francisco Los Angeles Seattle Dallas master.txt Atlanta is chill and laid-back. I love Los Angeles. Coming to Dallas was the right choice. New York is so busy! San Francisco is fun. Moving to Boston soon! Go to Seattle in the summer. ...

5. Shell Programming and Scripting

Separate Text File into Two Lists Using Python

Hello, I have a pretty simple question, but I am new to Python and am trying to write a simple program. Put simply, I want to take a text file that looks like this: 11111 22222 33333 44444 55555 66666 77777 88888 and produce two lists, one containing the contents of the left column, one the...

6. Shell Programming and Scripting

Python/GTK Text Wrap Question . . .

Greetings! After some cut-and-try, I've cobbled together the following bit of basic code:#!/usr/bin/python import gtk class PyApp(gtk.Window): def __init__(self): super(PyApp, self).__init__() self.set_size_request(250, 250) ...

7. Programming

Python Text substitute

I need to substitute only comma with dot in string like this: 5,4but not sure how to do this. This does not work: text = sub('(,)', '(.)', text)

8. Shell Programming and Scripting

Search and Replace+append a text in python

Hello all, I have a verilog file as following (part of it): old.v: bw_r_rf16x32 AUTO_TEMPLATE ( 1957 // .rst_tri_en (mem_write_disable), 1958 .rclk (clk), 1959 .bit_wen (dva_bit_wr_en_e), 1960 .din ...

9. UNIX for Beginners Questions & Answers

Print a python script down a list in a text file without printing a lot combinations

In a python script I have 2 files printing side by side on the same line. I want to have 1 of the files to be already displayed at once while the other file print down the list in the file and it still will produce new lines. I want to do it like that to reduce printing a lot of lines and...

LEARN ABOUT DEBIAN

dist::zilla::plugin::distini

Dist::Zilla::Plugin::DistINI(3pm)			User Contributed Perl Documentation			 Dist::Zilla::Plugin::DistINI(3pm)

NAME

       Dist::Zilla::Plugin::DistINI - a plugin to add a dist.ini to newly-minted dists

VERSION

       version 4.300020

DESCRIPTION

       This plugins produces a dist.ini file in a new dist, specifying the required core attributes from the dist being minted.

       This plugin is dead simple and pretty stupid, but should get better as dist minting facilities improve.	For example, it will not specify
       any plugins.

       In the meantime, you may be happier with a dist.ini template.

ATTRIBUTES

   append_file
       This parameter may be a filename in the profile's directory to append to the generated dist.ini with things like plugins.  In other words,
       if your make this file, called plugins.ini:

	 [@Basic]
	 [NextRelease]
	 [@Git]

       ...and your profile.ini includes:

	 [DistINI]
	 append_file = plugins.ini

       ...then the generated "dist.ini" in a newly-minted dist will look something like this:

	 name	 = My-New-Dist
	 author  = E. Xavier Ample <example@example.com>
	 license = Perl_5
	 copyright_holder = E. Xavier Ample
	 copyright_year   = 2010

	 [@Basic]
	 [NextRelease]
	 [@Git]

AUTHOR

       Ricardo SIGNES <rjbs@cpan.org>

COPYRIGHT AND LICENSE

       This software is copyright (c) 2012 by Ricardo SIGNES.

       This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.

perl v5.14.2							    2012-06-21					 Dist::Zilla::Plugin::DistINI(3pm)