Resolved: Introduction to Data and Data Science Ques 22
Hi,
Great work on putting the course together; really well done.
If I wanted to know how many companies were VC financed I can sum() on that column, so is the column really categorical?
Thanks for your feedback.
Regards,
Jason
Hi Jason!
Thanks for reaching out and thanks for the kind words!
Great question! The data is all three at the same time.
Regarding "categorical" - the values, 1 and 0, do not represent quantities or magnitudes (i.e. any sort of meaningful numeric scale). They correspond to "yes" or "no" in a certain way (i.e. "Has this company been financed by the government?" - Yes = 1, No = 0). So, the data is categorical.
So, as kind of data, we have provided the right correct answer, so to speak. Even if Excel would allow you to sum up/count the number of financed companies, this doesn't change the data type stored in this column per sé.
Hope this helps.
Kind regards,
Martin
Hi Martin,
Thanks for clarifying.
Best regards,
Jason
You are very welcome!
Best,
Martin