SplitMerge 0.0.2.post3
Split & Merge utilities for large csv files.

# Split-Merge Package

Splitting a large CSV file into multiple small csv files for better processing using Split features at your local disk & Merge will merge back to small files into one large file. This is a first sample version. 

### Limitations

## Split

As of now, this will create splitted file with the extension known as "_splitted_". Make sure that your original file should not contain the same naming pattern.

> Your source file name for example - customer_addr_20180112.csv
>
> Your split file name will will be given below: 

    1__customer_addr_20180112__splitted_.csv
    2__customer_addr_20180112__splitted_.csv
    ....
    N__customer_addr_20180112__splitted_.csv

> Where N would be any number based on the size of the file.
> Bye default, each chunk will contain at least 30000 or less number of records.

## Merge

For merge, it will pick-up from the temp directory as mentioned in the bottom of this page. And, it will create a final merged file with this kind of naming convention -

    customer_addr_20180112_.csv

Final, file will be places under process directory. Please refer the bottom of this page for directory structure & placement of the main calling file.

This package requires pandas & regular expression package to be installed in your python environment.

Sample Code to use this library. You can name it as -> 

------------------------------------------------------------------------------------------
                         callSplitMergeFiles.py
------------------------------------------------------------------------------------------

    from SplitMerge.clsSplitFiles import clsSplitFiles
    from SplitMerge.clsMergeFiles import clsMergeFiles
    import re
    import platform as pl
    import os

    def main():
        print("Calling the custom Package for large file splitting..")
        os_det = pl.system()

        print("Running on :", os_det)

        ###############################################################
        ###### User Input based on Windows OS                  ########
        ###############################################################

        srcF = str(input("Please enter the file name with extension:"))
        base_name = re.sub(r'[0-9]','', srcF)
        srcFileInit = base_name[:-5]

        if os_det == "Windows":
            subdir = "\\temp\\"
            path = os.path.dirname(os.path.realpath(__file__)) + "\\"
        else:
            subdir = "/temp/"
            path = os.path.dirname(os.path.realpath(__file__)) + '/'

        ###############################################################
        ###### End Of User Input                                 ######
        ###############################################################

        ###############################################################
        ######             Begining of Split Process             ######
        ###############################################################

        t = clsSplitFiles(srcF, path, subdir)
        ret_val = t.split_files()

        if ret_val == 0:
            print("Splitting Successful!")
        else:
            print("Splitting Failure!")

        print("-"*30)

        ###############################################################
        ######               End of Split Process                ######
        ###############################################################

        print("Finally, Merging small splitted files to make the same big file!")

        ###############################################################
        ######             Begining of Merge Process             ######
        ###############################################################

        y = clsMergeFiles(srcFileInit, path)
        ret_val1 = y.merge_file()

        if ret_val1 == 0:
            print("Merge Successful!")
        else:
            print("Merge Failure!")

        print("-"*30)

        ###############################################################
        ######               End of Merge Process                ######
        ###############################################################


    if __name__ == "__main__":
        main()

------------------------------------------------------------------------------------------
                 End Of Sample Code - callSplitMergeFiles.py
------------------------------------------------------------------------------------------

> Bug Fix: 1. Module loading issue fixed.
>          2. Source & Target directory as per developer's choice.
> Dependancy Package: You need to install followig packages in order to run this package -
>
>                     pip install pandas
>                     pip install regex
------------------------------------------------------------------------------------------
    Directory Structure shoould be like ->
------------------------------------------------------------------------------------------
    -> \callSplitMergeFiles.py
    -> \process\
    -> \src_file\
    -> \temp\
------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------