BoomplayTemplate.py

Go to the documentation of this file.

import re
 
class BoomplayTemplate:
    def date(self, filename):
        """Sets date column given the filename (it contains the date)
           For example gyrostream-pty-ltd_boomplay_202207_Monthly-Sales_TERR1.txt
        Args:
            filename (str): current filename
        Returns: date_str (str)
        """
        # 'gyrostream-pty-ltd_boomplay_202207_Monthly-Sales_TERR1.txt'
        date = re.findall(r'_20\d{4}', filename)[0]
        date = date.replace("_", "")
        date_str = date[:4]+"-"+date[4:]+"-01"
        # df["date_from_file"] = date_str
        # df["date_from_file"] = df["date_from_file"].astype("datetime64")
        return date_str