Mercurial > repos > deepakjadmin > mayatool3_test2
diff docs/scripts/txt/AnalyzeTextFilesData.txt @ 0:4816e4a8ae95 draft default tip
Uploaded
author | deepakjadmin |
---|---|
date | Wed, 20 Jan 2016 09:23:18 -0500 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/docs/scripts/txt/AnalyzeTextFilesData.txt Wed Jan 20 09:23:18 2016 -0500 @@ -0,0 +1,283 @@ +NAME + AnalyzeTextFilesData.pl - Analyze numerical coulmn data in TextFile(s) + +SYNOPSIS + AnalyzeTextFilesData.pl TextFile(s)... + + AnalyzeTextFilesData.pl [-c, --colmode colnum | collabel] [--columns + "colnum,[colnum,...]" | "collabel,[collabel,...]" | All] [--columnpairs + "colnum,colnum,[colnum,colnum]..." | + "collabel,collabel,[collabel,collabel]..." | AllPairs] [-d, --detail + infolevel] [-f, --fast] [--frequencybins number | + "number,number,[number,...]"] [-h, --help] [--indelim comma | semicolon] + [--klargest number] [--ksmallest number] [-m, --mode + DescriptiveStatisticsBasic | DescriptiveStatisticsAll | All | + "function1, [function2,...]"] [-o, --overwrite] [--outdelim comma | tab + | semicolon] [-p, --precision number] [-q, --quote yes | no] [-r, --root + rootname] [--trimfraction number] [-w, --workingdir dirname] + TextFiles(s)... + +DESCRIPTION + Anaylze numerical column data in *TextFile(s)* using a combination of + various statistical functions; Non-numerical values are simply ignored. + For *Correlation, RSquare, and Covariance* analysis, the count of valid + values in specifed column pair must be same; otherwise, column pair is + ignored. The file names are separated by space. The valid file + extensions are *.csv* and *.tsv* for comma/semicolon and tab delimited + text files respectively. All other file names are ignored. All the text + files in a current directory can be specified by **.csv*, **.tsv*, or + the current directory name. The --indelim option determines the format + of *TextFile(s)*. Any file which doesn't correspond to the format + indicated by --indelim option is ignored. + +OPTIONS + -c, --colmode *colnum | collabel* + Specify how columns are identified in TextFile(s): using column + number or column label. Possible values: *colnum or collabel*. + Default value: *colnum*. + + --columns *"colnum,[colnum,...]" | "collabel,[collabel]..." | All* + This value is mode specific. It's a list of comma delimited columns + to use for data analysis. Default value: *First column*. + + This value is ignored during *Correlation/Pearson Correlation* and + *Covariance* data analysis; -coulmnparis option is used instead. + + For *colnum* value of -c, --colmode option, input values format is: + *colnum,colnum,...*. Example: + + 1,3,5 + + For *collabel* value of -c, --colmode option, input values format + is: *collabel,collabel,..*. Example: + + ALogP,MolWeight,EC50 + + --columnpairs *"colnum,colnum,[colnum,colnum,...]" | + "collabel,collabel,[collabel,collabel,...]" | AllPairs* + This value is mode specific and is only used for *Correlation, + PearsonCorrelation, or Covariance* value of -m, --mode option. It is + a comma delimited list of column pairs to use for data analysis + during *Correlation* and *Covariance* calculations. Default value: + *First column, Second column*. + + For *colnum* value of -c, --colmode option, input values format is: + *colnum,colnum,[colnum,colnum]...*. Example: + + 1,3,5,6,1,6 + + For *collabel* value of -c, --colmode option, input values format + is: *collabel,collabel,[collabel,collabel]..*. Example: + + MolWeight,EC50,NumN+O,PSA + + For *AllPairs* value of --columnparis option, all column pairs are + used for *Correlation* and *Covariance* calculations. + + -d, --detail *infolevel* + Level of information to print about column values being ignored. + Default: *1*. Possible values: 1, 2, 3, or 4. + + -f, --fast + In this mode, all the columns specified for analysis are assumed to + contain numerical data and no checking is performed before analysis. + By default, only numerical data is used for analysis; other types of + column data is ignored. + + --frequencybins *number | "number,number,[number,...]"* + Specify number of bins or bin range to use for frequency analysis. + Default value: *10* + + Number of bins value along with the smallest and largest value for a + column is used to group the column values into different groups. + + The bin range list is used to group values for a column into + different groups; It must contain values in ascending order. + Examples: + + 10,20,30 + 0.1,0.2,0.3,0.4,0.5 + + The frequency value calculated for a specific bin corresponds to all + the column values which are greater than the previous bin value and + less than or equal to the current bin value. + + -h, --help + Print this help message. + + --indelim *comma | semicolon* + Input delimiter for CSV *TextFile(s)*. Possible values: *comma or + semicolon*. Default value: *comma*. For TSV files, this option is + ignored and *tab* is used as a delimiter. + + --klargest *number* + Kth largest value to find by *KLargest* function. Default value: *2* + Valid values: positive integers. + + --ksmallest *number* + Kth smallest value to find by *KSmallest* function. Default value: + *2*. Valid values: positive integers. + + -m, --mode *DescriptiveStatisticsBasic | DescriptiveStatisticsAll | All + | "function1, [function2,...]"* + Specify how to analyze data in TextFile(s): calculate basic or all + descriptive statistics; or use a comma delimited list of supported + statistical functions. Possible values: *DescriptiveStatisticsBasic + | DescriptiveStatisticsAll | "function1,[function2]..."*. Default + value: *DescriptiveStatisticsBasic* + + *DescriptiveStatisticsBasic* includes these functions: *Count, + Maximum, Minimum, Mean, Median, Sum, StandardDeviation, + StandardError, Variance*. + + *DescriptiveStatisticsAll*, in addition to + *DescriptiveStatisticsBasic* functions, includes: *GeometricMean, + Frequency, HarmonicMean, KLargest, KSmallest, Kurtosis, Mode, + RSquare, Skewness, TrimMean*. + + *All* uses complete list of supported functions: *Average, + AverageDeviation, Correlation, Count, Covariance, GeometricMean, + Frequency, HarmonicMean, KLargest, KSmallest, Kurtosis, Maximum, + Minimum, Mean, Median, Mode, RSquare, Skewness, Sum, SumOfSquares, + StandardDeviation, StandardDeviationN, StandardError, + StandardScores, StandardScoresN, TrimMean, Variance, VarianceN*. The + function names ending with N calculate corresponding values assuming + an entire population instead of a population sample. + + Here are the formulas for these functions: + + Average: See Mean + + AverageDeviation: SUM( ABS(x[i] - Xmean) ) / n + + Correlation: See Pearson Correlation + + Covariance: SUM( (x[i] - Xmean)(y[i] - Ymean) ) / n + + GeometricMean: NthROOT( PRODUCT(x[i]) ) + + HarmonicMean: 1 / ( SUM(1/x[i]) / n ) + + Mean: SUM( x[i] ) / n + + Median: Xsorted[(n - 1)/2 + 1] for even values of n; (Xsorted[n/2] + + Xsorted[n/2 + 1])/2 for odd values of n. + + Kurtosis: [ {n(n + 1)/(n - 1)(n - 2)(n - 3)} SUM{ ((x[i] - + Xmean)/STDDEV)^4 } ] - {3((n - 1)^2)}/{(n - 2)(n-3)} + + PearsonCorrelation: SUM( (x[i] - Xmean)(y[i] - Ymean) ) / SQRT( SUM( + (x[i] - Xmean)^2 ) (SUM( (y[i] - Ymean)^2 )) ) + + RSquare: PearsonCorrelation^2 + + Skewness: {n/(n - 1)(n - 2)} SUM{ ((x[i] - Xmean)/STDDEV)^3 } + + StandardDeviation: SQRT ( SUM( (x[i] - Mean)^2 ) / (n - 1) ) + + StandardDeviationN: SQRT ( SUM( (x[i] - Mean)^2 ) / n ) + + StandardError: StandardDeviation / SQRT( n ) + + StandardScore: (x[i] - Mean) / (n - 1) + + StandardScoreN: (x[i] - Mean) / n + + Variance: SUM( (x[i] - Xmean)^2 / (n - 1) ) + + VarianceN: SUM( (x[i] - Xmean)^2 / n ) + + -o, --overwrite + Overwrite existing files. + + --outdelim *comma | tab | semicolon* + Output text file delimiter. Possible values: *comma, tab, or + semicolon* Default value: *comma*. + + -p, --precision *number* + Precision of calculated values in the output file. Default: up to + *2* decimal places. Valid values: positive integers. + + -q, --quote *yes | no* + Put quotes around column values in output text file. Possible + values: *yes or no*. Default value: *yes*. + + -r, --root *rootname* + New text file name is generated using the root: <Root>.<Ext>. + Default new file name: <InitialTextFileName><Mode>.<Ext>. Based on + the specified analysis, <Mode> corresponds to one of these values: + DescriptiveStatisticsBasic, DescriptiveStatisticsAll, AllStatistics, + SpecifiedStatistics, Covariance, Correlation, Frequency, or + StandardScores. The csv, and tsv <Ext> values are used for + comma/semicolon, and tab delimited text files respectively. This + option is ignored for multiple input files. + + --trimfraction *number* + Fraction of data to exclude from the top and bottom of the data set + during *TrimMean* calculation. Default value: *0.1*. Valid values: > + 0 and < 1. + + -w --workingdir *text* + Location of working directory. Default: current directory. + +EXAMPLES + To calculate basic statistics for data in first column and generate a + NewSample1DescriptiveStatisticsBasic.csv file, type: + + % AnalyzeTextFilesData.pl -o -r NewSample1 Sample1.csv + + To calculate basic statistics for data in third column and generate a + NewSample1DescriptiveStatisticsBasic.csv file, type: + + % AnalyzeTextFilesData.pl --columns 3 -o -r NewSample1 Sample1.csv + + To calculate basic statistics for data in MolWeight column and generate + a NewSample1DescriptiveStatisticsBasic.csv file, type: + + % AnalyzeTextFilesData.pl -colmode collabel --columns MolWeight -o + -r NewSample1 Sample1.csv + + To calculate all available statistics for data in third column and all + column pairs, and generate NewSample1DescriptiveStatisticsAll.csv, + NewSample1CorrelationMatrix.csv, NewSample1CorrelationMatrix.csv, and + NewSample1MolWeightFrequencyAnalysis.csv files, type: + + % AnalyzeTextFilesData.pl -m DescriptiveStatisticsAll --columns 3 -o + --columnpairs AllPairs -r NewSample1 Sample1.csv + + To compute frequency distribution of data in third column into five bins + and generate NewSample1MolWeightFrequencyAnalysis.csv, type: + + % AnalyzeTextFilesData.pl -m Frequency --frequencybins 5 --columns 3 + -o -r NewSample1 Sample1.csv + + To compute frequency distribution of data in third column into specified + bin range values, and generate NewSample1MolWeightFrequencyAnalysis.csv, + type: + + % AnalyzeTextFilesData.pl -m Frequency --frequencybins "100,200,400" + --columns 3 -o -r NewSample1 Sample1.csv + + To calculate all available statistics for data in all columns and column + pairs, type: + + % AnalyzeTextFilesData.pl -m All --columns All --columnpairs + AllPairs -o -r NewSample1 Sample1.csv + +AUTHOR + Manish Sud <msud@san.rr.com> + +SEE ALSO + JoinTextFiles.pl, MergeTextFilesWithSD.pl, ModifyTextFilesFormat.pl, + SplitTextFiles.pl, TextFilesToHTML.pl + +COPYRIGHT + Copyright (C) 2015 Manish Sud. All rights reserved. + + This file is part of MayaChemTools. + + MayaChemTools is free software; you can redistribute it and/or modify it + under the terms of the GNU Lesser General Public License as published by + the Free Software Foundation; either version 3 of the License, or (at + your option) any later version. +