Using the Tesla Patents Database Download Tesla Patents Database dataset, please examine each variable and answer the following when cleaning the data:

Does the data set contain any duplicate records $($not duplicate data points$)?$ If so$,$ highlight these in red using conditional formatting.

Are there structural issues with any of the data that need to be corrected? If so$,$ please correct them in red.

Are there any instances where you find N$/$A in the data? If so$,$ please replace them with a zero in red.

Are there any instances of missing data? If so$,$ please replace them with UNKNOWN in red.

Parse the inventor's name, using the semicolon as the delimiter.