esProc Download
Recent Comments
Even For OBIEE, its… on 6 Desktop BI Tools Marco on Seven analysis tools: R langua… lkafle on An example to illustrate hadoo… lkafle on Five methods of data consolida…
Monthly Archives: August 2014
Comparison Between esProc’s Sequence Table Object and R’s Data Frame
Both esProc and R language are typical data processing and analysis languages with two-dimensional structured data objects. They are all good at multi-step complex computations. However their two-dimensional structured data objects are quite different from each other in the underlying … Continue reading
Posted in esProc/R/Python/Perl, FAQ
Leave a comment
Methods of Accessing Excel Files by R language
There are many ways for R language to access Excel files, but each has its weaknesses. For example, xlsx package has complicated code and supports only Excel 2007; RODBC has too many restrictions, is difficult to understand and unstable and … Continue reading
Posted in esProc/R/Python/Perl, FAQ
Tagged access, esProc, excel files, python, R Language
Leave a comment
Functions of esProc/R/Python/Perl in Structured Data Process by Comparison :Chapter 20. Comparing Sorting Performance
For each script, use built-in library function to sort data, and develop a bubble sort algorithm. Then their performances are presented by comparison. esProc Perl sublib_sort{ # Use sort library function my … Continue reading
Posted in esProc/R/Python/Perl, Structured Data Process
Tagged esProc, performanc, Perl, python, R Language
Leave a comment
Using SQL in esProc (II)
5 Comparison between common SQL statements and esProc syntax 1) Select * from Query results are as follows: 2) Select … from Get designated fields from the table. Both A2 and A3 have the same query … Continue reading
Posted in Application, Big Data, Data Analytics, Program Language, Reporting tool
Tagged esProc, SQL
Leave a comment
Using SQL in esProc (I)
In esProc, we can use not only the SQL to retrieve data from databases, but also the preliminary database query results to perform further analyses and operations to solve some complicated problems which are difficult to deal with only with … Continue reading
Posted in Application, Big Data, Data Analytics, Program Language, Reporting tool
Tagged esProc, SQL
Leave a comment
A Code Example of Computing Link Relative Ratio and Year-on-year Comparison with esProc
Link relative ratio refers to comparison between the current data and data of the previous period. The interval is usually one month. For example, divide sales amount of April by that of March, and you get the link relative ratio … Continue reading
Posted in Application, Program Language
Tagged comparison, esProc, relative ratio, year-on-year
Leave a comment
Functions of esProc/R/Python/Perl in Structured Data Process by Comparison :Chapter 19.Access to Large File
esProc The concept of file cursor is available in esProc, which can be used to perform a series of operations on large file, for example, sorting, filtering, grouping, connecting, aggregating data, etc.. You can select appropriate option to perform its … Continue reading
Posted in esProc/R/Python/Perl, Structured Data Process
Tagged esProc, large files, Perl, python, r
Leave a comment
Functions of esProc/R/Python/Perl in Structured Data Process by Comparison :Chapter 18.Writing to Excel
esProc It can be written out with one statement, and you can specify the field name, sheet name to be exported. =file(“d:/data.xls”).exportxls(tbl,id:id,name:name,score:score,…;”sheet1″) Perl #!perl use strict; use Win32; useCwd; use Win32::OLE qw(in with); … Continue reading
Posted in esProc/R/Python/Perl, Structured Data Process
Tagged esProc, excel, Perl, python, r, write
Leave a comment
Comparison of esProc and R Language in Processing Text Files
As languages for data computations, both esProc and R language have rich functions to process text files. They have many similarities in basic usage, as well as obvious differences, such as in the aspect ofprocessing files with fixed column width … Continue reading
Code Examples of Processing json Data with esProc
esProc can process json data. Here we’ll introduce some of the applications through examples. 1. Analyzing and generating json data with esProc; 2. Data-interchange between esProc and application program through json; 3.Reading jsonfile data inesProc. A. Analyzing and generating json data … Continue reading
esProc 