convert tab separated file to simple X-Y chart

since1993 · 08-27-2009, 12:47 PM

I wrote a script which analysis apache logs. This script generates a tab separated data file. There is two columns in the data. The first column is a file name accessed from remote. The second column shows how many times a file access.

The data file looks like below

[data file]
index.html 352
logo.jpg 422
introduction 34

I am looking for a linux command drawing a chart corresponding data.

PS> of course, I know that I can draw the chart in OpenOffice Calc. That's not what I need. Because there is some steps to do for a simple chart drawing. If there is a command line tool, then I can write a script that drawing a chart when the data file is updated.

Tinkster · 08-27-2009, 01:12 PM

I'm not sure what exactly you're trying to do, but with
"drawing a graph" and "command line" gnuplot spings to
mind ... maybe completely wrong, and not what you're
after. Of course there's also GD - can be used nicely
from PHP scripts (possibly other languages too, but I
only remember PHP of the top of my head).

Cheers,
Tink

since1993 · 08-27-2009, 02:09 PM

I have a data file. I want to draw a bar chart using the data file. I am looking for a linux program which can do this.

The data file contains two data. One is file names. The other one is size of the file.

[filesize.dat]
a 21
b 4
c 27

a, b and c are file names. The numbers are size of those files in kilobytes. X axis is file name. Y axis is file size. Of course, I can bring data file into OpenOffice Calc and use Chart tool. However, I have to look this graph very often. I need a linux program simply draw bar-chart.

COMMAND filesize.dat --bar_style

It would be great if I can see the simple graph with a command like above. Is there any program like this?

PS> it is hard for me to learn OOo BASIC programming or to learn gnuplot.

Tinkster · 08-27-2009, 02:23 PM

I've merged your two *VERY* closely related threads.

w1k0 · 08-27-2009, 03:09 PM

This is the original data file:

$ cat filesize.dat

Code:

index.html 352
logo.jpg 422
introduction 34

This is a script preparing data for gnuplot:

$ cat script.sh

Code:

#!/bin/sh

IFS.old=$IFS
IFS='
'

declare -i n=0
> filesize.numbered.dat
> filesize.numbered.gnuplot.dat

for line in `cat filesize.dat`
do
    n=$n+1
    echo "$n $line" >> filesize.numbered.dat
    echo "$n `echo $line | awk '{print $2}'`" >> filesize.numbered.gnuplot.dat
done

This is human readable output with numbered lines:

$ cat filesize.numbered.dat

Code:

1 index.html 352
2 logo.jpg 422
3 introduction 34

This is gnuplot readable output with numbered lines but without file’s names:

$ cat filesize.numbered.gnuplot.dat

Code:

1 352
2 422
3 34

This is the session with gnuplot:

$ gnuplot

Code:

$ gnuplot 
gnuplot> set terminal png color
gnuplot> set output 'filesize.numbered.gnuplot.png'
gnuplot> plot 'filesize.numbered.gnuplot.dat' with lines
gnuplot> quit

This is your chart: filesize.numbered.gnuplot.png.

I don't insist it's the simplest solution. Someone can suggest something simpler or more elegant.

w1k0 · 08-27-2009, 03:18 PM

This is another way of number lines and remove file's names:

$ grep -n '' filesize.dat | sed 's/:/ /'

$ grep -n '' filesize.dat | sed 's/:/ /' | awk '{print $1,$3}'

since1993 · 08-27-2009, 06:07 PM

Thank you for helping me.
I would like to show the file names for each bars. Since files keep being added, edited and deleted, I thought I have to write a scipt to label each bars.

I found another solution at `http://www.burningcutlery.com/derek/bargraph/. Somebody already wrote a perl script. And, I could finish my job.

I am a lazy man. I didn't like to spend a day or more to understand gunplot and to write a script generating customized gnuplot command file.