Dense dataframe to temporal database

Dense dataframe to a temporal database

Description

A temporal database represents a sparse and binary representation of items occurring at a particular timestamp in a dataframe. The steps to convert a dataframe into a temporal database is as follows:

1. Initialize the dense2DB class by passing the following three parameters:
   1. inputDataFrame - the dataframe that needs to converted into a database
   2. thresholdValue - this value will be used to convert a non-binary data frame into a binary database
   3. condition - The condition that needs to employed on the threshold value. Currently, the users can specify the following six constraints: >, >=, <, <=, ==, and !=.
2. Call ‘createTemporal(outputFileName)’ method to store the dataframe as a temporal database.

Sample code

from PAMI.extras.DF2DB import denseDF2DB as pro
import pandas as pd

# Objective: convert the above dataframe into a transactional database with items whose value is greater than or equal 1.
db = pro.denseDF2DB(inputDF=pd.DataFrame('mentionDataFrame'), thresholdValue=1, condition='>=')
# Convert and store the dataframe as a temporal database file
db.convert2TemporalDatabase(outputFile='/home/userName/temporalDB.txt')
# Getting the fileName of the temporal database
print('The output file is saved at ' + db.getFileName())