Download

Introduction Last updated: 2020-07-21

HappyReader is a text reader that handles huge files at ease. It is designed by Dr. Saed Sayad to help increase the readability of large text files in few seconds. It can view, edit large text files, do statistical operations, filter, split and transpose files.

Loading

You can open files that can be in a format of any delimiter separator file in the Happy Reader.

Loading a File

  1. Click the folder icon on the header bar as shown below.
  2. Find the file you want to open and click open.
  3. The file will be loaded and displayed in the application.

File details appear as below:

  1. File path.
  2. No of Rows in a file
  3. Time it took to load the file.
  4. Delimiter used for separating data.

Navigation

Navigating through the data is not difficult.It can be done using some very simple keystrokes.

Moving Between Cells

  1. Use the arrow keys on your keyboard to move from one cell to another.
  2. Use the feature key to move horizontally to the right. Hold the Shift key and press the feature key to move horizontally to the left.
  3. Use the Enter key to move vertically downward.

Selecting Multiple Cells

  1. Select the first cell in the data range.
  2. Hold the Shift key.
  3. Select the last cell in the data range.

Selecting Entire Row

You can click on the black arrow to select the entire data of that row.

Selecting a range of Rows

  1. On the rightmost top corner,the range selector for rows can be seen as shown below. Enter the range of rows and hit enter to display the data accordingly.
  2. To increment the no of rows displayed by one, click on the arrow.
  3. To increment the no of rows displayed by 10, click on the arrow.

Save subset of data

  1. Enter the range of rows you want to select.
  2. Click the save icon.
  3. A new window will open to save the file. The file will be saved in the same path as source.

Options

In-memory

The In-Memory option can be used for a frequently accessed large file to reduce the processing time for the operations performed on these files. This can be explained further using the example below.

  1. Before using the in-memory option, below is the time taken for loading a 237 MB file.
  2. Select the in-memory option.
  3. After using in-memory below is the time taken for loading the same file.

Text Qualifier

Count

To get the total count of the rows click on the Count feature as shown in the figure below.

Clean Up

Cleanup feature/option is used to clean the erroneous data

Replace

To alter certain characters or ASCII values, make use of Replace feature on the menu bar.The detailed steps are as follows:.

  1. Click the Replace feature on the menu bar.
  2. A Replace dialog box will open.
  3. On the left, select either of the options available.
    1. Characters
    2. ASCII
  4. Enter the value in the left textbox to replace.
  5. On the right, select the category to which the values should be replaced to.
    1. Characters
    2. ASCII
  6. Enter the corresponding value in the right textbox to replace with.
  7. By checking the Ignore Header the values in the headers will not be replaced.
  8. Click Replace & Save. The file with replaced values will be saved with 'replace.csv' appended to the original filename in the same location as the source file.

Reorder

Reorder feature on the menu tab reorders and slices the columns in the data file .The detailed steps are as follows:

  1. Click the Reorder feature on the menu bar.
  2. A Reorder and Slice dialog box will open.
  3. You can select the required columns by selecting the respective checkbox.
  4. You can select all columns by checking the selected checkbox.
  5. In order to reorder the column sequence.
    1. Select the column to reorder.It will appear blue in color.
    2. You can toggle up or down using arrows keys.
    3. Click the Apply button.The file will be reordered ,sliced and saved with 'reorder.csv' appended to the original filename in the same location as the source file.
  6. A .txt file can be reordered and sliced, as shown below
    1. Click the folder icon on the dialog box.
    2. Select the text file containing the selected columns.
    3. The .txt file must be as per below format.
    4. Click the Apply button.The file will be reordered ,sliced and saved with 'reorder.csv' appended to the original filename in the same location as the source file.
  7. You can save the modified sequence of columns using the save icon.
  8. Rename and save the file using the windows save file dialog box.

Filter

Filter (feature/property/attribute/option as deem fit) filters the data based on the column values.The detailed steps are as follows:

  1. Click the Filter feature on the menu bar.
  2. A Filter dialog box will open.
  3. Check the Column checkbox.The second Column checkbox is used for additional filtering.
  4. Select the attribute from the drop-down menu.
  5. Click on Values hyperlink to extract all unique values from that column.
  6. Select a value from the dropdown to filter.
  7. Filtering with two columns has the following options:
    1. AND:Filters rows considering both the column values mentioned.
    2. OR: Filters rows considering either of the column values mentioned.
  8. Data is filtered-in or filtered-out based on the selection
    1. INCLUDE: Includes data that matches the filtered condition, dropping the rest.
    2. EXCLUDE: Excludes data that matches the filtered condition, selecting the rest.
  9. Filter & Save, filters and saves the file in the same location as the source.

Stats

Stats feature performs univariate and bivariate analysis on the source data.

Categorical

You can select any categorical value and perform analysis as follows:

  1. Click on the column header /the column value (Both gives the analysis) of the categorical attribute.
  2. Click the Stats dropdown menu on the menu bar.
  3. In the dropdown menu, click categorical.
  4. A new window with a univariate analysis of the selected categorical attribute will be shown.

Numerical

You can select any Numerical value and perform analysis as follows:

  1. Click on the column header /the column value (Both gives the analysis) of the numerical attribute.
  2. Click the Stats dropdown menu on the menu bar.
  3. In the drop down menu select Numerical.
  4. A new window with a univariate analysis of the selected numerical attribute will be shown.

Categorical and Categorical

Select two categorical attributes to perform the bivariate analysis as follows:

  1. Click on the column header of first categorical attribute.
  2. Ctrl+ click or Shift+ click on the second categorical attribute.
  3. Click the Stats dropdown menu on the menu bar.
  4. In the dropdown menu, click on Cat & Cat option.
  5. A new window with a bivariate analysis of the selected categorical attributes will be shown.

Numerical and Numerical

Select two numerical attributes to perform the bivariate analysis as follows:

  1. Click on the column header of first numerical attribute.
  2. Ctrl+ click or Shift+ click on the second numerical attribute.
  3. Click the Stats dropdown menu on the menu bar.
  4. In the dropdown menu, click on Num & Num option.
  5. A new window with a bivariate analysis of the selected numerical attributes will be shown.

Categorical and Numerical

Select a numerical and categorical attribute to perform the bivariate analysis as follows:

  1. Click on the column header of a categorical attribute.
  2. Ctrl+ click or Shift+ click on a numerical attribute.
  3. Click the Stats dropdown menu on the menu bar.
  4. In the dropdown menu, click on Cat & Num option.
  5. A new window with a bivariate analysis of the selected categorical and numerical columns will be shown.

Tokens

Tokens feature is used to generate tokens in a text field along with the count of each token.

  1. Select the column that you want to tokenize.
  2. Go to the Stats dropdown menu and select Tokens.
  3. A new window with count and tokens(Key) will be appeared.

Add Random Sequence

"Add Random Sequence" will add a random sequence to the file from the selected range:

  1. Click on the Stats dropdown menu and select Add Random Sequence.
  2. A new window will appear asking for Number of random sequences.
  3. Enter the length of sequence in the textbox below.
  4. Click OK.The file will be saved with 'seq.csv' appended to the original filename in the same location as source file.

Extra

Under this dropdown menu, "Append Files", "Split Files" and "Transpose" features are listed .

Append Files

Append Files merges different files. Follow the below steps to append the files

  1. Click on Extra dropdown menu.
  2. Click on Append Files in the drop down menu.
  3. A new Append File window will pop up.
  4. Click on the Folder icon on the right hand top corner. A window will appear to select the folder containing the files.Select on the required folder.
  5. A list of files will appear on the window.
  6. Select the checkbox against the file you want to append.
  7. Check the Selected check box to select all files.
  8. Refresh button on top right corner refreshes the list of files.
  9. In the output textbox, provide the path to save the appended file.
  10. Check the Join by ID box to append files using ID.
  11. To append by rows click on Append by Rows button.
  12. To append by columns click on Append by Cols button.

Split Files

Split Files feature splits the file in a random or bootstrap manner.Follow below steps to split a file.

  1. Click on Extra dropdown menu.
  2. Click on Split Files in the drop down menu.
  3. A new Splitter window will pop up.
  4. Click on the folder icon to open the file to split.
  5. Select the remove header box to remove header in the split file.
  6. To split files by a random method choose Random option.
  7. To split files by a bootstrap method choose bootstrap option.
  8. Enter the number of subsets to split the file accordingly.
  9. Click Start and split files will be created at the same location as the source.

Transpose

Transpose feature transposes the files by interchanging rows and columns.The steps are as shown below.

  1. Click on the Extra dropdown menu.
  2. Click on Transpose feature.
  3. A new Transpose window will pop up.
  4. Click on the folder icon to open the file to transpose.
  5. Check on Transpose and Slice to transpose the file and split it.Provide the number of columns required in each split.
  6. Click on the Transpose & Save button.A transpose file will be created in the same location as the source.