Extracting words from a line- as column name and its corresponding numbers as values into the column
I have a column named "Fault"- where I have fault codes extracted from various devices. One of the fault code from a particular day is given below. "inverter Inverter 20 below limit: 0.96 Kilowatts/inverter (58.9 % of 1.63 Kilowatts) at 11/30/2019 7:30:00 AM (sun az: 123.4 el: 3.7) Duration: 4.00 hours inverter Inverter 23 below limit: 0.95 Kilowatts/inverter (57.9 % of 1.63 Kilowatts) at 11/30/20...