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!
