I have a use case whereby the source is a CSV file - tabular format (in rows) with entries of XML elements within. A sample structure as below:
The target orientation of the data I'd like to get to is to be able to extract those XML values, those fields becoming a column so a row of data describes all the attributes of that action logged at that time.
There are also entries where the XML structure is "nested".
Under this circumstance, Do you have tips and tricks to share with us so we can realize the data set that is cleaned and ready for analysis?
Please sign in to leave a comment.