Need to convert SQL output into Line Protocol using python

/*I have to convert below set of string in a file to Line Protocol."

Here is the Output(Example):

name : Memory USAGE alert id : 13 state : alerting

name : CPU USAGE alert id : 12 state : alerting

name : DISK USAGE alert id : 11 state : alerting

Expected format: LINE PROTOCOL

alerting,name=MemoryUSAGEalert id=13 alerting,name=CPUUSAGEalert id=12 alerting,name=DISKUSAGEalert id=11 Kindly help...*/