8 Warnings about Excel Wolfram Data Types | Linked Data Types

The new Wolfram Data Types are pretty interesting, but there are things that you have to watch out for. This video is a sampling of 8 things that are weird about the data types and how they work within Excel.

1:19 Fascinating and Incomplete Entries
2:12 Unexpected Translation
3:29 False Negatives. When looking for a movie, the result was “no data found.” But, I was able to find it.
4:15 Sometimes results take up several cells. You’ve gotta watch for the data to show vertical or horizontal.
6:04 No Sports Data. On the Wolfram site sports data is available. But it’s not available to import into Excel.
7:10 Watch Your Measurements. I imported the heights of celebrities. It was in meters and had to be converted to feet & inches.
8:17 Paste-as-Values and Flash fill don’t work with Wolfram Data Types.
9:47 Names don’t equal Names. Be careful. Do you want a celebrity’s birth name (Paul Hewson) or the name they go by (Bono)?

#Wolfram
#DataTypes
#ExcelDataTypes

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2