The data file is a large data file from the Federal government.
I would like to read the data using stat software packages.
The lines end with \r\n .
Field 4 is a text field. It can have a \n character embedded in it. Stat software package tends to incorrectly split a record with a \n character into two records. Commas are a legitimate part of field 4 (so I should not have had it removed in the sample output). Field 4 is all caps.
I have tried things like
extracting field 1 (the id variable) and field 4 (the value of intereset) from a file
changing "," to "comma" because lowercase letters are not in the datafile
change the pipe to a comma.
the 2nd awk statement was to reshape fields 1 and 4 so that there a line with the id variable for each field 4.
Hi,
I have an input data file :-
Test4599,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,2,2,Rain
Test90,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,Not Rain
etc....
I wanted to transpose these data to:-... (2 Replies)
Hi,
I did read a few posts on the subjects, tried out a few solutions, but did not solve my problem.
https://www.unix.com/302121568-post11.html
https://www.unix.com/shell-programming-scripting/137953-large-file-columns-into-rows-etc-4.html
Please help. Problem very similar to the second link... (15 Replies)
Hi I'm looking to transpose Linux data from a daily report that logs every 10mins like below.
After the first "comma" I need the daily total for Col2 and Col3 transposed like below.
The new transposed format below will then be exported to Microsoft Excel for Reporting.
Any help would be... (9 Replies)
Hello. very new to shell scripting and would like to know if anyone could help me.
I have data thats being pulled into a txt file and currently have to manually transpose the data which is taking a long time to do.
here is what the data looks like.
Server1 -- Date -- Other -- value... (7 Replies)
I can no longer find my commands, but I use to be able to transpose data with common fields from a single column to rows using a command line. My data is separated as follows:
NAME=BOB
ADDRESS=COLORADO
PET=CAT
NAME=SUSAN
ADDRESS=TEXAS
PET=BIRD
NAME=TOM
ADDRESS=UTAH
PET=DOG
I would... (7 Replies)
Hi I have below requirement, need help
One file contains the meta data information and other file would have the data, match the column from file1 and with file2 and extract corresponding column value and display in another file
File1:
CUSTTYPECD
COSTCENTER
FNAME
LNAME
SERVICELVL
... (1 Reply)
Hi All,
I have sort of a case to transpose data from rows to column
input data
Afghanistan|10000|1
Albania|25000|4
Algeria|25000|7
Andorra|10000|4
Angola|25000|47
Antigua and Barbuda|25000|23
Argentina|5000|3
Armenia|100000|12
Aruba|20000|2
Australia|50000|2
I need to transpose... (3 Replies)
Hi
I have the following sample of data: my full data dimention is 900,000* 1119
rs987435 C G 1 1 1 0 2
rs345783 C G 0 0 1 0 0
rs955894 G T 1 1 2 2 1
rs6088791 ... (7 Replies)
Discussion started by: marwah
7 Replies
LEARN ABOUT DEBIAN
chart::clicker::data::dataset
Chart::Clicker::Data::DataSet(3pm) User Contributed Perl Documentation Chart::Clicker::Data::DataSet(3pm)NAME
Chart::Clicker::Data::DataSet - A collection of series
VERSION
version 2.83
SYNOPSIS
use Chart::Clicker::Data::DataSet;
use Chart::Clicker::Data::Series;
my @vals = (12, 19, 90, 4, 44, 3, 78, 87, 19, 5);
my @keys = (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
my $series = Chart::Clicker::Data::Series->new({
keys => @keys,
values => @vals
});
my $ds = Chart::Clicker::Data::DataSet->new({
series => [ $series ]
});
DESCRIPTION
Chart::Clicker::Data::DataSet is a set of Series that are grouped for some logical reason or another. DatasSets can be associated with
Renderers in the Chart. Unless you are doing something fancy like that you have no reason to use more than one in your chart.
max_key_count
Get the number of keys in the longest series. This will be set automatically.
ATTRIBUTES
context
Set/Get the context this DataSet will be charted under.
domain
Get the Range for the domain values
range
Get the Range for the... range values...
series
Set/Get the series for this DataSet
METHODS
add_to_series
Add a series to this dataset.
count
Get the number of series in this dataset.
get_series ($index)
Get the series at the specified index.
get_all_series_keys
Returns an array of keys representing the union of all keys from all DataSets.
get_series_keys
Returns the key at the specified position for every series in this DataSet.
get_series_values
Returns the value at the specified position for every series in this DataSet as an ArrayRef.
get_series_values_for_key
Returns the value for the specified key for every series in this DataSet as an ArrayRef.
largest_value_slice
Finds the largest cumulative 'slice' in this dataset.
AUTHOR
Cory G Watson <gphat@cpan.org>
COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Cold Hard Code, LLC.
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-22 Chart::Clicker::Data::DataSet(3pm)