Added Data Tranformations

-
One of the primary aims of this project was to add more data transformations.

Here is a list of commits which helps us achieve these goals:
  1. Added text transformations for external data
    • Uppercase, which sets all text in the selected columns to upper case. 
    • Lowercase, which sets all text in the selected columns to lower case. 
    • Capitalize Each Word, which makes all words in the selected column start with a capital letter and sets all subsequent letters in a word to lower case. 
    • Trim, which removes any leading or trailing whitespace characters from text. 
  2. Added aggregate functions for external data 
    • Sum, which returns the sum of values in the column. 
    • Average, which returns the average of values in the column. 
    • Min, which returns the minimum of the values in the column. 
    • Max, which returns the maximum of the values in the column. 
  3. Added ReplaceNullTransformation 
  4. Added date and time transformations
    • Date String, gives the date from datetime value.
    • Year, gives the year from datetimevalue.
    • Start of Year, gives the first day of the year.
    • End of Year, gives the last day of the year.
    • Month, give the month number of the year.
    • Month Name, give the name of the month represented by the datetime value.
    • Start of Month, gives the first day of the month.
    • End of Month, gives the last day of the month.
    • Day, gives the day from the datetime value.
    • Day of Week,  gives the day of the week of the datetime value.
    • Day of Year, gives the day of the year represented by the datetime value.
    • Quarter, gives which quarter the date falls in.
    • Start of Quarter, gives the first date of the quarter.
    • End of Quarter, gives the last date of the quarter.
    • Time, gives the time part from the datetime value.
    • Hour, gives the hour from the datetime value.
    • Minute, gives the minute from datetime value.
    • Second, gives the seconds from the datetime value. 
  5. Added number transformations for external data  
    • Round allows you to round the numbers in the column up to a given number of decimal places.
    • Round Up rounds the numbers in the column up to the nearest whole number.
    • Round Down rounds the numbers in the column down to the nearest whole number.
    • Absolute Value returns the absolute value of the numbers in the column.
    • Cube returns the cube of the numbers.
    • Square returns the square of the numbers.
    • Square Root returns the square root of the numbers.
    • Is Even returns TRUE if the values in the column are even.
    • Is Odd returns TRUE if the values in the column are odd.
    • Sign returns 1 if the values in the column are positive, -1 if they are negative, and 0 otherwise.  
    • Logarithm
      • Natural returns the natural logarithm
      • Base-10 returns the base-10 logarithm.

Comments

Post a Comment

Popular posts from this blog

Debugging LibreOffice with GDB

-
Getting started To debug LibreOffice with GDB you need to build LibreOffice with debug symbols. You can either choose to build LO with symbols for the entire project or for selected modules. For building with symbols for the entire project you can use ./autogen.sh --enable-debug For building  with symbols for specific modules ./autogen.sh --enable-debug --enable-selective-debuginfo = "sc/"   More information for setting up GDB can be found here How to debug . Setting up pretty printers Basics Debugging boils down to the following set of actions: Set up a break point Run the program Step through the code Analyze the variables as you go Handling Crashes while debugging The most common reasons for crashes are either an exception occurred or an assertion failures. In case of Exceptions, you can stop GDB at the point where the exception occurred by setting up a breakpoint using catch throw and then analyze the backtrace (generated using bt )....
Read more

GSoC Summary

-
Working with Lireoffice during GSoC has been a great learning experience. It has helped me get better at C++ and taught me how real world applications are built. I also spent most of my time at the debugger rather than writing code which has helped me improve my debugging skills. It also taught me what a great tool git is for managing commits and has been helpful in more than one occasion.  My mentors, and the Libreoffice community has been very helpful and have guided me whenever I got stuck. It feels good to be a part of such a great community. Below is a list of tasks that was done as part of the GSoC project and also a list of tasks that I wanted to, but could not finish during the period. Work Done Added Data Transformations https://gerrit.libreoffice.org/#/c/58152/   https://gerrit.libreoffice.org/#/c/58151/   https://gerrit.libreoffice.org/#/c/56886/   https://gerrit.libreoffice.org/#/c/56862/   https://gerrit.libreoffice.org/#/c/567...
Read more