A Data Science Central Community
Generally, Java programmers use poi or other open source packages to read and compute Excel data. These open source packages support low-level programming, which increases the overall learning cost and complicates the operation. But with the help of esProc, Java can avoid these problems.…Continue
Added by Jessica May on October 8, 2014 at 12:26am — No Comments
The join statements of the database can be used conveniently to perform the operation of alignment join. But sometimes the data is stored in the text files, and to compute it in Java alone we need to write a large number of loop statements. This makes the code cumbersome. Using esProc to help with programming in Java can solve the problem easily and quickly. Let’s look at how this works…Continue
Added by Jessica May on September 28, 2014 at 8:00am — No Comments
It is common to use R language to group and summarize data of files. Sometimes we may find ourselves processing comparatively big files which have smaller computed result and bigger source data. We cannot load them wholly to the memory when we need to compute them. The only solutions could be batch importing and computing as well as result merging. We’ll use an example in the following to illustrate the way of R language to group and summarize data from big text files.
Here is a file,…Continue
The computing power of SQL for mass structured data is complete, that is to say, it is impossible to find anything that SQL cannot compute. But its support layer is too low, which can lead to over-elaborate operation in practical application.…Continue
Added by Jessica May on July 27, 2014 at 9:30pm — No Comments
Both esProc and R language are typical data processing and analysis languages with two-dimension…Continue
Added by Jessica May on July 21, 2014 at 1:36am — No Comments
Text files often brings headache for data analysts, are there any more convenient way for text files process? I prepare a case on how esProc deal with it, including import various text files; process big text files; visit text files of hdfs; as well as general operations, such as, file moving, deleting and checking whether a file exists. The following will illustrate these functions through examples. …Continue
Added by Jessica May on July 14, 2014 at 1:30am — No Comments
OLAP is an important constituent part of BI(business intelligence).
Understood literally, OLAP is online analytical processing, that is, users conduct analytical operation on real-time business data.
But, currently the concept of OLAP is seriously narrowed, and only it refers to operations such as conducting drilling,…Continue
Added by Jessica May on May 27, 2014 at 8:00pm — No Comments