Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 956 Categories, Downloaded 50.223.661 Times

Aggregate data using any number of multiple columns 1.0

  Date Added: March 24, 2013  |  Visits: 319

Aggregate data using any number of multiple columns

Report Broken Link
Printer Friendly Version


Product Homepage
Download (46 downloads)



Surprisingly, I never came across the simple solution of aggregating data using accumarray. Accumarray needs indices supplied to aggregate too. Combining this with the Unique function, the user can quickly and conveniently aggregate data using any available and appropriate funciton supported by Accumarray. The indices are created using the unique function.This function is especially useful for aggregating timeseries of data say from hourly to daily, monthly, seasonal, etc. Like summing up precipitation, or averaging flow rates, etc.Expected inputs is a timeseries of data with all but the last column used for generate unique combinations, and the last column is what the summarization is done on.Additionally, I wrote a similar function (accumSeasonTS.m) aggregating data to seasons as defined by the solstices and equinoxes when given two columns of data: serial date and associated data values.datain = r x cfn = supplied string specifying a valid summary statistic function.Example: @sum, @max, @min, etc.dataout = r x cWritten by: Jeff Burkey King County- DNRP email: jeff.burkey@kingcounty.gov June 9, 2009Syntax: [dataout] = accumTS(datain,fn)Example: d = accumTS(din,@max);

Requirements: No special requirements
Platforms: Matlab
Keyword: Accumseasontsm Columns Defined Equinoxes Generate Seasons Serial Similar Solstices
Users rating: 0/10

License: Shareware Size: 10 KB
USER REVIEWS
More Reviews or Write Review


AGGREGATE DATA USING ANY NUMBER OF MULTIPLE COLUMNS RELATED
Miscellaneous  -  SQL-like ORDER BY function for lists 1.0
This script contains a function that allows you to easily sort a list by multiple columns in ascending and descending order similar in function to the ORDER BY clause in SQL.
 
Programming  -  ClassEditor 2.23
Open a Java class file binary to view or edit strings, attributes, methods and generate readable reports similar to the javap utility. In built verifier checks changes before saving the file. Easy to use Java Swing GUI. This is a tool...
174.08 KB  
Libraries  -  Parse::RecDescent 1.94
Parse::RecDescent is a Perl module to generate Recursive-Descent Parsers. SYNOPSIS use Parse::RecDescent; # Generate a parser from the specification in $grammar: $parser = new Parse::RecDescent ($grammar); # Generate a parser from the...
122.88 KB  
Password Managers  -  Password Generator Professional 2006 4.0
Password Generator Professional 2006 is a powerful, flexible, secure and ultra fast password generator! Create: passwords, login details/usernames, serial numbers, unique keys, e-mail addresses and more! Export to text, XML, HTML, CSV and Excel...
2.38 MB  
Password Generators  -  SF Password Generator Pro 1.5
SF Password Generator Pro is a professional program designed for generating strong passwords easily and quickly. Using SF Password Generator Pro, you can easily create extremely strong, complex passwords up to 255-character length and lists...
472.51 KB  
Graphics Editors  -  pixelle rc.1.0.0
An image transformation tool where arbitrary arithmetic transformations can be done pixel by pixel through user defined formulas written in java. Similar in concept to convolution matrices, but allowing any arbitrary expression to generate new...
5.08 MB  
Development Tools  -  NeoClassic Growth Model in Dynamic Economic Theory 1.0
Demonstration of Neoclassic Growth Model in Dynamic Economics, deterministic model, using both discrete optimization and interpolation method. Utility function and production function defined seperately. Generate plot to show the Policy function...
10 KB  
Multimedia  -  cmtdtool 1.0
cmtdtool is an assistant tool for model-based testing in MBD processes. Initially, this tool is developed for JMAAB-CMTD-WS (JMAAB: Japan Automotive Advisory Board, CMTD-WS: Control Model Test Design Workshop). After several improvements upon...
3.15 MB  
Utilities  -  chkcsv 0.8.0.0
chkcsv.py is a Python module and program that checks the format and content of a comma-separated-value (CSV) or similar delimited text file. It can check whether required columns are present, and the type, length, and pattern of each column.
10.24 KB  
HTML Utilities  -  EOReporter 1.3
EOReporter is a command-line tool generate files (documentation, usually) based on information in an EOModel. Files can be generated on a per-entity, per-model, or per-model group basis. Some provided templates generate HTML documentation similar...
144 KB  
NEW DOWNLOADS IN SCRIPTS, DEVELOPMENT TOOLS
Scripts  -  Freelancer Script 5.05
Main Features: 100% Secured. Email Support (3 Years). FREE Updates (3 Years). Post projects. Featured projects. Private projects. Sealed projects. Edit/delete projects. Select freelancers....
5.49 MB  
Scripts  -  B2B Script 4.20
Main Features: 100% Secured. Email Support (3 Years). FREE Updates (3 Years). Sign-up Account (Registration of account). Lead generation tools (for the sellers). Email verification to...
5.49 MB  
Scripts  -  B2C Script 5.06
Main Features: 100% Secured. Email Support (3 Years). FREE Updates (3 Years). The script comes with totally editable site colors, icons and graphics Multilevel categories allows extensive browsing Admin can change Category ordering or...
5.49 MB  
Scripts  -  Social Networking Script 2.86
Main Features: 100% Secured. Email Support (3 Years). FREE Updates (3 Years). Registration with name, email, password, date of birth etc. User can add multiple school, college, university with start...
5.49 MB  
Scripts  -  Business Networking Script 8.04
Main Features: 100% Secured. Email Support (3 Years). FREE Updates (3 Years). Ajax based interface. Profile creation. Different types of profile. Profile for jobseekers, employers and employed...
5.49 MB  
Development Tools  -  Aml2CHM 3.50
Those who use the popular Aml Pages text editor might be looking out for a way of generating help files from their text and notes. Aml2CHM is a plug-in that was developed to offer people a quick and efficient way of converting Aml Pages documents...
549.99 KB  
Development Tools  -  VMP Viewer 1.0
This is a very rudimentary tool to visualize the VMP files generated by BrainVoyager. Useful to share files with people who do not have BV.
10 KB  
Development Tools  -  Sending reports and timestamped file by emailing 1.0
main executing reference usage:[1] usage_send_mail.mIllustrates email sending with multiple separate files or single timestamped tar file. Attachment failure is properly handled, with continuation of report emailing without the attachment.[2]...
768 KB  
Development Tools  -  IrisMVC 2.0 rc1
IrisMVC is an OOP PHP framework that developers can use as a strong and secure foundation to build on various web applications following the Model-View-Controller (MVC) pattern. It provides the basic functionality developers need, without...
51.2 KB  
Development Tools  -  7-Zip for Script 4.42
7-Zip is a file archiver with a high compression ratio.Features:- High compression ratio in new 7z format with LZMA compression- Supported formats:- Packing / unpacking: 7z, ZIP, GZIP, BZIP2 and TAR- Unpacking only: RAR, CAB, ISO, ARJ, LZH, CHM,...
624.64 KB