Convert your data: Grouping

- [Instructor] A lot of times you get data…that's really sort of transactional…and it looks like this.…I have a row of data for every sort…of data point along the way.…I'm back to my minimum wage data.…I have minimum wage at the category.…I have the amount, so three dollars and ten cents…and the year, 1980.…This was the minimum wage in this year.…Here is the minimum wage in 1981,…et cetera, et cetera, et cetera.…Now, I have the same data for the price of bread…and each one in a row and the price…of gasoline, et cetera.…This data is the same data that we've…been looking at in some of the other…videos in this course, but long story short…each row is a transaction it just makes…it harder to do certain things.…

It's not impossible, but it makes it…a little bit harder for instance, for me…to generate line charts for every…single on of these elements because…unlike before where I could use keyboard…shortcuts and jump around and generate charts.…Now if I want it to do a line chart…I have to sort of click and drag…and make sure I stop at the right place…