utilities/praw_processor.py

from typing import Dict, List

import pandas as pd

from utilities.my_logger import setup_logger

# Setup logging
logger = setup_logger(__name__)


def preprocess_praw_data(submissions: List[Dict]) -> pd.DataFrame:
    """
    Preprocesses praw data into a DataFrame.

    Parameters:
    - submissions: List of submission dictionaries.

    Returns:
    - pd.DataFrame: Preprocessed DataFrame.
    """

    # Convert the submissions list to a DataFrame
    praw_df = pd.DataFrame(submissions)

    # Convert 'date' column to datetime format
    praw_df.date_utc = pd.to_datetime(praw_df.date_utc)

    # Remove 'poster_link' column if it exists
    if 'poster_link' in praw_df.columns:
        del praw_df['poster_link']

    # Extract the 4th element from 'permalink' as 'id'
    praw_df['id'] = praw_df.permalink.str.split('/').str[4]

    return praw_df