handle ($12.3) type of string in currency conversion

[s-github-2]

Brief Description

enhance currency conversion using 'accounting' to support common excel negative currency strings like ($12.3)

I would like to propose...

Example API

uses existing currency conversion function when handling the 'accounting' format with the following code to handle currency strings - minor edit on existing code makes it more useful

    outcome = (
        df[column_name].astype(str)
        .str.strip()
        .str.replace("$", "", regex=False)
        .str.replace(",", "", regex=False)
        .str.replace(")", "", regex=False)
        .str.replace("(", "-", regex=False)
        .replace({"-": 0.0})
        .astype(float)
    )
    return df.assign(**{column_name: outcome})
# ...

[samukweku]

@s-github-2 thanks. if it is ok with you, kindly create a PR for this? I'll tag other @pyjanitor-devs/core-devs to get their inputs

[ericmjl]

@samukweku I'll take this one on. With the infra changes in #1540, once that is merged in, I'll feel much better about implementing features like these.