Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Print multiple columns in scientific notation Post 303017949 by supernono06 on Friday 25th of May 2018 10:51:34 AM
Old 05-25-2018
Print multiple columns in scientific notation

Hi everybody,

I have file 1 with 15 columns, I want to change the formatting of the numbers of columns 10,11 and 12 in the scientific notation.
I used the Following script:

Code:
awk '{print $10}' file1.dat | awk '{printf "%.2e\n", $1}' > file2.dat
awk '{print $11}' file1.dat | awk '{printf "%.2e\n", $1}' > file3.dat
awk '{print $12}' file1.dat | awk '{printf "%.2e\n", $1}' > file4.dat

I have two questions:

a)How to make changes simultaneously and get these three columns printed in one file? I tried this, but only the column 10 was printed:

Code:
awk '{print $10, $11, $12 }' file1.dat | awk '{printf "%.2e\n", $1, $2, $3 }' > file5.dat

b) Is it possible to get the formatting conversion of columns 10,11,12 directly in file1.dat, without having to generate extra files?

Thank you!




Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!

Last edited by RudiC; 05-25-2018 at 12:25 PM.. Reason: Added CODE tags.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to Convert scientific notation to normal ?

Hell friends, I wrote a script gets the summation of particular column using awk. The awk output is given in scientific notation. How do I convert the scientific notation to normal. My awk syntax : awk '{sum += $2} END { printf sum }' temprep.txt Out put is like 1.5365e+07 I want it as... (2 Replies)
Discussion started by: maheshsri
2 Replies

2. UNIX for Dummies Questions & Answers

How to add/multiply numbers with scientific notation (2.343e-5)

Hi, I'm need to do some addition and multiplication of scientific nottaion numbers, in the form 34.23423e-10 for example. I was echoing the list of numbers to stdout, then using bc -l, then I find that this does not seem to work for numbers with exponential notation. Could someone help me out... (1 Reply)
Discussion started by: chugger06
1 Replies

3. Shell Programming and Scripting

Bash Scientific Notation

Hello there, I have a script that must be written in bash that has to deal with reading in values from a file (in scientific notation), and requires executing some mathematical operations with them. What is the easiest way to go about doing this/converting it to float to use | bc, etc.? ... (7 Replies)
Discussion started by: amit_57
7 Replies

4. UNIX for Dummies Questions & Answers

Conversion of scientific notation

Hello All, Hope all is well, Suppose I have a program that extracted data into a file called: progcros.in. I attached the file but I renamed it progcros.txt. I think that my mess up the column alignment. Anyways, in several columns there are numbers listed, however the numbers... (4 Replies)
Discussion started by: gingburg
4 Replies

5. Shell Programming and Scripting

Rounding scientific notation

Hi Friends, I have following 50,000 records in .txt file. I need to round field 3, 4, & 5 to 3 decimal places. 11|A123|-2.64216408856E01|3.64216408856E01|4.64216408856E-01 11|A123|0|-5.64216408856E01|0 11|A123|0|0|0 11|A123|-99999999|-99999999|-99999999... (4 Replies)
Discussion started by: ppat7046
4 Replies

6. Programming

Reading Scientific notation from file and storing in array

Hi, I am trying to read a set of numbers that are in scientific notation into a file so I can do some math on them, but when I display the array contents the numbers aren't the same as the numbers in the file. Could someone explain why? Thanks. int main() { double fArray; ... (3 Replies)
Discussion started by: Filter500
3 Replies

7. Linux

Find and print in multiple columns

Hi all, My input file is : 0 13400000 sil 13400000 14400000 a 14400000 14900000 dh 14900000 15300000 a 15300000 16500000 R 16500000 17000000 k 17000000 17300000 u 17300000 17600000 th 17600000 17900000 sil 17900000 18400000 th 18400000 18900000 a 18900000 19600000 g 19600000 19900000... (1 Reply)
Discussion started by: girlofgenuine
1 Replies

8. Shell Programming and Scripting

Converting from scientific notation to normal

Hi everyone, I need to convert some numbers that are written in scientific notation to normal notation. Here is a sample line from my data file; "1",1,-1,0,0,502,0,0.00000000000E+00,0.00000000000E+00,0.35591163544E+03,0.35591163548E+03,0.50400001928E-02,0.,-1. first of all, my data file... (4 Replies)
Discussion started by: hayreter
4 Replies

9. Shell Programming and Scripting

Perl: scientific notation to decimal notation

hello folks, I have few values in a log which are in scientific notation. I am trying to convert into actual decimal format or integer but couldn't able to convert. Values in scientific notation: 1.1662986666666665E-4 2.0946799999999998E-4 3.0741333333333333E-6 5.599999999999999E-7... (2 Replies)
Discussion started by: scriptscript
2 Replies

10. Shell Programming and Scripting

Help with filter result (scientific notation) by using awk

Input file: data1 0.05 data2 1e-14 data1 1e-330 data2 1e-14 data5 2e-60 data5 2e-150 data1 4e-9 Desired output: data2 1e-14 data1 1e-330 data2 1e-14 data5 2e-60 data5 2e-150 I would like to filter out those result that column 2 is less than 1e-10. Command try: (1 Reply)
Discussion started by: cpp_beginner
1 Replies
MUPLOT(1)							   User Commands							 MUPLOT(1)

NAME
muplot - plot a multi-curve figure from multiple data by using Gnuplot SYNOPSIS
muplot [OPTION]... [STYLE] [FILE] [AXES] [FILE] [AXES] ... DESCRIPTION
Muplot is a simple, non-interactive gnuplot-wrapper to plot a multi-curve figure from multiple data (files). It can produce PostScript, PDF, PNG or JPEG output file formats. OPTIONS
--help|-H display help --version output version and license message -h display short help -V print program version number -s create PostScript file -S send PostScript output to STDOUT (the same as '-s -o -') -n create PNG file -j create JPEG file -p create PDF file (requires the gnuplot "pdfcairo" driver) -c <cmd> execute gnuplot command(s) (the default plot style is used) -m monochrome plot (valid only for PostScript) -l set plot size to 800x600 (valid for PNG and JPEG) -o base name of the output file -q quiet mode (all messages except errors to be suppressed) -i ignore local command file './.muplotset' -I <file> specify an alternative command file instead of './.muplotset' Styles: l lines p points lp lines and points (default) pp circle points d dots b boxes g grid e errorbars - default used columns are 1:2:3 (x:y:yerror) a fields with arrows; The data file has a special format in this case. Use 'prefield' to prepare such data files. dt=<fmt> date/time series with the specified format; For example: dt="%H:%M.%S@%H:%M" where the first part, in front of "@", defines the data format, and the second part defines the format that will be used for tic labels. Here, hours and minutes are separated by `:', respectively minutes and seconds by `.' Another example could be a date: dt="%Y-%m-%d". u=<fmt> user specified format as defined in Gnuplot Axes: x:y,x:y-z columns in the file defining the x/y-axes of the curve(s); Default are 1:2 or 1:2:3 for data with errors. In case that only one col- umn is provided the default axes are 0:1 - the x-axis will be a simple index then. File(s) could be a single file name whereas '-' means <stdin>, many files enclosed in '' or "" like "file1 file2 file3", or any valid shell pattern as for example "*.dat". The files '$HOME/.muplotset' and './.muplotset', if existing, will be included at the beginning of the gnu- plot script. The command block between "#BEGIN" and "#END" in those files will be pasted to the end of the script. If you want that the global '$HOME/.muplotset' is ignored, create in your local directory a file named '.muplotset.noglobal'. In case you want to view the out- put, define the env variable MUPLOT_VIEWER and export it, for example: MUPLOT_VIEWER="xpdf -z page"; export MUPLOT_VIEWER Then the program will prompt you to view the plot, and after confirmation the viewer will present the graphics. If the postscript file for- mat is chosen ('-s' option), and MUPLOT_VIEWER is not defined, the viewer is preset to 'gv', and per default you are prompted to view the output. To disable this behavior, set MUPLOT_VIEWER="". EXAMPLES
1) On X-terminal view a multi-curve plot of data files with extension 'dat' muplot l "*.dat" 2) Print a sinus curve in black-and-white color on a PostScript printer muplot -m -S -c "set title 'Function f(x)=sin(x)'; plot sin(x);" | lpr 3) Plot data from file "example.dat" using columns 1:2, 3:4, and 3:5 as x/y-axes in the multi-curve plot; a PostScript file with the name "example.ps" is automatically created. muplot -s lp example.dat 1:2,3:4-5 4) Create graphics in PDF format reading data from file "example.1.dat" (columns 1:2), and from file "example.2.dat" (columns 3:4) muplot -p lp example.1.dat 1:2 example.2.dat 3:4 5) View data where the third column is a date of the form 'yyyy-mm-dd' cat example_counts_per_day.dat | muplot dt="%Y-%m-%d" - 3:1 REPORTING BUGS
Report bugs to <gnu@mirendom.net> COPYRIGHT
Copyright (C) 1996-2009, 2011-2012 Dimitar Ivanov License: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. muplot 3.2.1 February 2012 MUPLOT(1)
All times are GMT -4. The time now is 10:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy