Category Archives: esProc/R/Python/Perl

esProc compare with r-language, perl, python.

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 | Tagged , , , , | Leave a comment

Comparison of Loop Function in esProc and R Language

Loop function can traverse every member of an array or a set, express complicated loop statements with simple functions, as well as reduce the amount of code and increase readability. Both esProc and R language support the loop function. The … Continue reading

Posted in esProc/R/Python/Perl, FAQ | Tagged , , , | Leave a comment

Comparison of esProc and R Language in Processing External Text Files

As languages for data computations, both esProc and R language have rich functions to process external text files. They have many similarities in basic usage, as well as obvious differences, such as in the aspect of processing files with fixed … Continue reading

Posted in esProc/R/Python/Perl, FAQ | Tagged , , , | Leave a comment

esProc Helps Process Heterogeneous DataSources in Java – MongoDB

MongoDB does not support join directly.The unity JDBC recommended by the official website can perform the join operation after retrieving data out. But the advanced functions, like join, group, functions and expressions, are only provided by the paid version of … Continue reading

Posted in esProc/R/Python/Perl, Java Assistant, MongoDB | Leave a comment

esProc Integrates HeterogeneousData Sources for Report Development

In addition to conventional databases, data sources of a reporting tool could also involve JSON files, MongoDB, txt files, Excel and HDFS files. Normally reporting tools can handle a single data source, but they are unable to manage various data … Continue reading

Posted in esProc/R/Python/Perl, Reporting tool | Leave a comment

esProc Performs Dynamic Cross-database MERGE Operation

The MERGE statement provided by databases like MSSQL and ORACLE is very convenient for updating tables. But it is not as convenient as it is expected to be when the source table and target table exist in different databases. In … Continue reading

Posted in esProc/R/Python/Perl, Structured Data Process | Tagged , , , , | Leave a comment

esProc Assists Java in Merging Text Files to Excel

Problem source:http://bbs.csdn.net/topics/390842850  . In this case, you need to merge data from all text files in a given directory and export it to an Excel file. Each of these text files has tab-seperated data with one row and three columns. … Continue reading

Posted in esProc/R/Python/Perl, Program Language, Structured Data Process | Tagged , , , , | Leave a comment