Setting up your data
In this task, you are going to use data from the ASX for a Company that sells shark repellent systems and prepare it for charting. The first step is to tidy up and format the data.
이 연습은 강의의 일부입니다
Google Sheets로 배우는 데이터 시각화
연습 안내
- Remove the blank row and standardize your decimal places such that the numbers in columns
B:Ehave three decimal places. - Change the format of the date in
I1so that it has the same format as the dates inColumn A.- To do so you will need to select 'Format', and then 'Number' from the menu bar (or alternatively, you can use the '123' dropdown menu from the toolbar).
- Depending on options available to you, you may need to select additional date formats by selecting 'More Formats', and then 'More date and time formats'. This menu will provide you with advanced formatting options.
- Your new format should have the month, day, and year as an integer, separated by a hypthen!
