<jupyter_start><jupyter_text>test = '---------- Forwarded message ---------\r\nFrom: \r\nDate: Thu, Mar 25, 2021 at 4:14 PM\r\nSubject: Fwd: query\r\nTo: \r\n\r\n\r\nhello developer, the customer said blah blah. help\r\n\r\n\r\n\r\n---------- Forwarded message ---------\r\nFrom: lim wilfred \r\nDate: Tue, Mar 23, 2021 at 5:25 PM\r\nSubject: Re: query\r\nTo: W<NAME> Lim \r\n\r\n\r\nThank you for your assistance.\r\n\r\nOn Tue, Mar 23, 2021 at 5:25 PM <NAME>  wrote:\r\n\r\n> How can I help you?\r\n>\r\n> please tell me more\r\n>\r\n> regards,\r\n>\r\n> helpdesk\r\n>\r\n> On Tue, Mar 23, 2021 at 5:24 PM lim wilfred \r\n> wrote:\r\n>\r\n>> hello, i cannot log in\r\n>>\r\n>>\r\n>> help\r\n>>\r\n>>\r\n>>\r\n>> help\r\n>>\r\n>\r\n'<jupyter_code>s = '---------- Forwarded message ---------\r\nFrom: Phoebe <<EMAIL>>\r\nDate: Fri, Mar 19, 2021 at 9:32 AM\r\nSubject: Fwd: FW: [CASE:217438] FW: Swimsafer Test Booking\r\nTo: <<EMAIL>>\r\n\r\n\r\n\r\nWarm Regards,\r\n<NAME>ie\r\nProduct Director\r\nIAPPS Pte Ltd\r\n3 Fusionopolis Way, Symbiosis #13-25 S(138633)\r\n[O] 6463 1795   [F] 6778 5300\r\nWebsite: www.iappsasia.com\r\nFacebook: www.facebook.com/iappsasia\r\nYoutube: www.youtube.com/user/iAPPSasia\r\n\r\n\r\n\r\n\r\n---------- Forwarded message ---------\r\nFrom: Phoebe <<EMAIL>>\r\nDate: Fri, Mar 19, 2021 at 9:31 AM\r\nSubject: Re: FW: [CASE:217438] FW: Swimsafer Test Booking\r\nTo: Active SG Helpdesk <<EMAIL>>\r\nCc: <<EMAIL>>\r\n\r\n\r\nHi Helpdesk\r\n\r\nPleasae provide us the screenshot or error message shown. Also, please\r\nexplain the steps taken by user and hence causing user to say "unable to\r\nbook"\r\n\r\nThanks\r\n\r\nWarm Regards,\r\n<NAME>\r\nProduct Director\r\nIAPPS Pte Ltd\r\n3 Fusionopolis Way, Symbiosis #13-25 S(138633)\r\n[O] 6463 1795   [F] 6778 5300\r\nWebsite: www.iappsasia.com\r\nFacebook: www.facebook.com/iappsasia\r\nYoutube: www.youtube.com/user/iAPPSasia\r\n\r\n\r\n\r\n\r\nOn Thu, Mar 18, 2021 at 8:54 AM Active SG Helpdesk <<EMAIL>>\r\nwrote:\r\n\r\n> Hi All,\r\n>\r\n> Able to assist on the following issue as the earliest assessment the\r\n> instructor is able to book is in May and not in March/April.\r\n>\r\n> Thank you!\r\n>\r\n> Warmest Regards,\r\n> Yuan Ting\r\n>\r\n> ActiveSG Technical Helpdesk\r\n> iAPPS Pte Ltd\r\n> 3 Fusionopolis Way, #13-24/25\r\n> Symbiosis, Singapore 138633\r\n> Helpline: 65941388\r\n>\r\n>\r\n> ------------------------------\r\n>\r\n> *From:* Muham<EMAIL>FARR<EMAIL>.sg\r\n> *Date:* 17/03/2021 04:28pm\r\n> *To:* <EMAIL>\r\n> *Cc:* Jayme_JACOB@<EMAIL>.sg\r\n> *Subject:* [CASE:217438] FW: Swimsafer Test Booking\r\n>\r\n> Hi Helpdesk,\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Could you advise me on the issue below. The instructor below is unable to\r\n> book for any assessments within March and April. He claims that the system\r\n> only allows for him to book in May at the earliest. Are you able to clarify\r\n> on the reason why?\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Warm regards,\r\n> Farris\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> *From:* <NAME> <<EMAIL>>\r\n> *Sent:* Wednesday, 17 March 2021 9:47 AM\r\n> *To:* <NAME> (SPORT) <<EMAIL>>; <NAME> (SPORT) <\r\n> <EMAIL>>\r\n> *Cc:* <NAME> from.TP (SPORT) <\r\n> <EMAIL>>\r\n> *Subject:* Re: Swimsafer Test Booking\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Hi,\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> I had checked with all the coaches from Jurong East complex sat 3pm to\r\n> 6pm, non of them had booked any swimsafer test for the month of mar and\r\n> apr. If no test booking had been made why I am unable to book test?\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Thanks!!!\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> ------------------------------\r\n>\r\n> *From:* <NAME> <<EMAIL>>\r\n> *Sent:* Tuesday, 16 March 2021 10:46 AM\r\n> *To:* <NAME> (SPORT) <<EMAIL>>; <NAME> (SPORT) <\r\n> <EMAIL>>\r\n> *Cc:* <NAME> from.TP (SPORT) <\r\n> <EMAIL>>\r\n> *Subject:* Re: Swimsafer Test Booking\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Hi,\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> I had checked with all the coaches from Jurong East complex sat 3pm to\r\n> 6pm, non of them had booked any swimsafer test for the month of mar and\r\n> apr. If no test booking had been made why I am unable to book test?\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Thanks!!!\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> On 16 Mar 2021 8:41 am, <NAME> <<EMAIL>> wrote:\r\n>\r\n>\r\n>\r\n> Hi,\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> I had checked with all the coaches from Jurong East complex sat 3pm to\r\n> 6pm, non of them had booked any swimsafer test for the month of mar and\r\n> apr. If no test booking had been made why I am unable to book test?\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Thanks!!!\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> ------------------------------\r\n>\r\n> *From:* <NAME> (SPORT) <<EMAIL>>\r\n> *Sent:* Monday, 8 March 2021 12:07 PM\r\n> *To:* <NAME> <<EMAIL>>; <NAME> (SPORT) <\r\n> <EMAIL>>\r\n> *Cc:* <NAME> from.TP (SPORT) <\r\n> <EMAIL>>\r\n> *Subject:* RE: Swimsafer Test Booking\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Hi Alex,\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> This means that the slots for assessments during March and April have been\r\n> taken up.\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Please choose the next earliest available date.\r\n>\r\n>\r\n>\r\n> *Kind Regards*,\r\n>\r\n>\r\n>\r\n> *<NAME>*\r\n> Foundation Sports Executive\r\n> ActiveSG | Sport Singapore\r\n> <EMAIL> | 3 Stadium Drive, Singapore 397630\r\n>\r\n>\r\n>\r\n> [image: Sport Singapore] <https://www.sportsingapore.gov.sg/>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> *CONFIDENTIALITY NOTICE:* This email may contain privileged and\r\n> confidential information. If you have been sent or have received this email\r\n> by mistake, please notify the sender and delete the email immediately. You\r\n> must not copy, use or disseminate the information contained in this email.\r\n> Nothing in this email is intended to nor shall it constitute any offer or\r\n> acceptance resulting in binding agreement, unless expressly stated\r\n> otherwise.\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> *From:* <NAME> <<EMAIL>>\r\n> *Sent:* Monday, 8 March 2021 11:54 AM\r\n> *To:* <NAME> (SPORT) <<EMAIL>>; <NAME> (SPORT) <\r\n> <EMAIL>>\r\n> *Cc:* Muhammad FARRIS from.TP (SPORT) <\r\n> <EMAIL>>\r\n> *Subject:* Re: Swimsafer Test Booking\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Hi,\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> I just tried again. Mar and Apr unable to book for test, earliest is may.\r\n> May I know what is the reason?\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Thanks!!!\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> ------------------------------\r\n>\r\n> *From:* <NAME> (SPORT) <<EMAIL>>\r\n> *Sent:* Monday, 8 March 2021 11:31 AM\r\n> *To:* <NAME> <<EMAIL>>; <NAME> (SPORT) <\r\n> <EMAIL>>\r\n> *Cc:* <NAME> from.TP (SPORT) <\r\n> <EMAIL>>\r\n> *Subject:* RE: Swimsafer Test Booking\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Hi Alex,\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Per the SwimSafer booking system, bookings can only be made 2 weeks prior\r\n> to the date of the test. This is to prevent double bookings.\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> As such, the system was not letting you make a booking as you were trying\r\n> to make one for the 13th of March on the 3rd of March.\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Do schedule for a later date that the system will allow.\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Thank you.\r\n>\r\n>\r\n>\r\n> *Kind Regards*,\r\n>\r\n>\r\n>\r\n> *<NAME>*\r\n> Foundation Sports Executive\r\n> ActiveSG | Sport Singapore\r\n> <EMAIL> | 3 Stadium Drive, Singapore 397630\r\n>\r\n>\r\n>\r\n> [image: Sport Singapore] <https://www.sportsingapore.gov.sg/>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> *CONFIDENTIALITY NOTICE:* This email may contain privileged and\r\n> confidential information. If you have been sent or have received this email\r\n> by mistake, please notify the sender and delete the email immediately. You\r\n> must not copy, use or disseminate the information contained in this email.\r\n> Nothing in this email is intended to nor shall it constitute any offer or\r\n> acceptance resulting in binding agreement, unless expressly stated\r\n> otherwise.\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> *From:* <NAME> <<EMAIL>>\r\n> *Sent:* Saturday, 6 March 2021 10:00 PM\r\n> *To:* <NAME> (SPORT) <<EMAIL>>\r\n> *Cc:* Jay<NAME> (SPORT) <<EMAIL>>; Muhammad FARRIS\r\n> from.TP (SPORT) <<EMAIL>>\r\n> *Subject:* Re: Swimsafer Test Booking\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Hi,\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>  I had been waiting for your colleague reply, are they still working at\r\n> sport singapore or quit already?\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Thanks!!!\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> ------------------------------\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> *From:* <NAME> (SPORT) <<EMAIL>>\r\n> *Sent:* Wednesday, 3 March 2021 10:56 AM\r\n> *To:* <NAME> <<EMAIL>>\r\n> *Cc:* <NAME> (SPORT) <<EMAIL>>; Muhammad FARRIS\r\n> from.TP (SPORT) <<EMAIL>>\r\n> *Subject:* RE: Swimsafer Test Booking\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Hi Alex\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> My colleague Jayme and Farris will assist you.\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Thanks\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> *<NAME>*\r\n> Team Lead\r\n> Active Ageing Development | Active Masters  | ActiveSG\r\n> <EMAIL> | T.65 6500 5172 | F. 65 63461842 | 3 Stadium\r\n> Drive, Singapore 397630\r\n>\r\n>\r\n>\r\n> [image: SportSG_EmailSignature_Generic2019]\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> [image: SG United] <https://www.sgunited.gov.sg/>\r\n>\r\n>\r\n>\r\n> *CONFIDENTIALITY NOTICE:* This email may contain privileged and\r\n> confidential information. If you have been sent or have received this email\r\n> by mistake, please notify the sender and delete the email immediately. You\r\n> must not copy, use or disseminate the information contained in this email.\r\n> Nothing in this email is intended to nor shall it constitute any offer or\r\n> acceptance resulting in binding agreement, unless expressly stated\r\n> otherwise.\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> *From:* <NAME> <<EMAIL>>\r\n> *Sent:* Wednesday, 3 March 2021 10:47 AM\r\n> *To:* SPORT swimsafer (SPORT) <<EMAIL>>\r\n> *Cc:* <NAME> (SPORT) <<EMAIL>>\r\n> *Subject:* Swimsafer Test Booking\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Hi,\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> I got problem with the test booking. I am unable to book swimsafer test on\r\n> 13 mar 2021 1515hrs at Jurong East Complex, I choose other dates and timing\r\n> also unable to book.\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n> Thanks!!!\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n>\r\n'
clean_text(s)
s.split("\r")
class issueType(enum.Enum):
    wallet = 0
    adminPanel = 1
    android = 2
    iOS = 3
    internet = 4
    receiptPrinter = 5
    goPanel = 6
    gymPanel = 7
    pos = 8
    iPad = 9
    nexus = 10
    wifi = 11
    web = 12
    merchant = 13
    turnstile = 14
    network = 15
    powerAdapter = 16
    scanner = 17
    switches = 18
    ocbcGateway = 19
    dbsGateway = 20
    serviceRequest = 21
    swimPanel = 22
    swimSafer = 23
    sep = 24
    booking = 25
    feedback = 26
    transaction = 27
    enquiries = 28
    membership = 29
    programme = 30
    publicProgramme = 31
    dataPatchReceipt = 32
print(issueType.iOS)
issueType.iOS.value
df
df = pd.read_csv('report.csv')
df.head()
df.isnull().sum()
df.shape
df = df.dropna()
df.isnull().sum()
df = df[['Case Description', 'Issue Type']]
df.to_csv('train.csv', index=False)
df.head()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.26356589147286824, 'fraction_numerical': 0.030273357813137496, 'mean_word_length': 2.8062111801242238, 'pattern_counts': {'":': 0, '<': 126, '<?xml version=': 0, '>': 798, 'https://': 3, 'lorem ipsum': 0, 'www.': 9, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 3, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '35145', 'license': 'MIT', 'n_tokens_mistral': 5978, 'n_tokens_neox': 5614, 'n_words': 1225, 'path': 'BAU Automation/.ipynb_checkpoints/BAU Automation-checkpoint.ipynb', 'repo_name': 'haojunsng/iapps_predictive_analytics', 'size': '13134'}