Build a data segmentation tool in R
Budget: $10 – $30 USD
I want to run a .csv file (like the file attached) through a piece of code which I would like built in SQL, which will (based on character recognition of certain key words onto ANY PART of the MainDesc input string from the BankStatements_Oberon.csv attachment) be able to categorise the transactions.
Transactions are characterised within the KeyWords&Descriptions.csv attachment by finding
- a character match anywhere on the MainDesc string on SearchTerm1, and
- if SearchTerm2 exists, a character match of SearchTerm2 anywhere within the MainDesc field,
- but not if if finds a character match of Excluding anywhere on Maindesc.
Then there should also be a final step which characterises transactions by a SearchTerm1 match and a positive or negative Amount
The return file should include both Description and Description2 fields from KeyWords&Descriptions.csv.
The program must import from CSV into SQL and export to CSV afterwards. I will need to take ownership of the code at the end of this project.
Transactions are characterised within the KeyWords&Descriptions.csv attachment by finding
- a character match anywhere on the MainDesc string on SearchTerm1, and
- if SearchTerm2 exists, a character match of SearchTerm2 anywhere within the MainDesc field,
- but not if if finds a character match of Excluding anywhere on Maindesc.
Then there should also be a final step which characterises transactions by a SearchTerm1 match and a positive or negative Amount
The return file should include both Description and Description2 fields from KeyWords&Descriptions.csv.
The program must import from CSV into SQL and export to CSV afterwards. I will need to take ownership of the code at the end of this project.