Difference between revisions of "Shuozhang DataPreparation"
| (7 intermediate revisions by the same user not shown) | |||
| Line 25: | Line 25: | ||
=Opting out the data files= | =Opting out the data files= | ||
| + | |||
The data from 2014-11-28 and 2015-11-15 has been removed from the analytics process because the weather on that two days are extremely cloudy and the sensor can not detect anything due to that all the band waves cannot penetrate the clouds. | The data from 2014-11-28 and 2015-11-15 has been removed from the analytics process because the weather on that two days are extremely cloudy and the sensor can not detect anything due to that all the band waves cannot penetrate the clouds. | ||
| Line 38: | Line 39: | ||
</tr> | </tr> | ||
</table> | </table> | ||
| + | <br/> | ||
| + | |||
=Choosing the data files to compare= | =Choosing the data files to compare= | ||
| Line 56: | Line 59: | ||
</tr> | </tr> | ||
</table> | </table> | ||
| + | |||
However, when comparing the NDVI values, the images are too blur to drive any conclusions. | However, when comparing the NDVI values, the images are too blur to drive any conclusions. | ||
| Line 61: | Line 65: | ||
[[File:Shuozhang03 cannot compare.jpg|800px]] | [[File:Shuozhang03 cannot compare.jpg|800px]] | ||
| − | = | + | Thus, only the images in June and September of 2015 and 2016 are compared respectively. |
| + | |||
| + | <br/> | ||
| + | |||
| + | |||
| + | =Combining the Data Sets= | ||
| + | |||
| + | After deciding which data tables are chosen to compare, a combination of two CSV files is performed in R:<br/> | ||
| + | |||
[[File:ShuozhangData manipulation.JPG|350px]] | [[File:ShuozhangData manipulation.JPG|350px]] | ||
| + | |||
| + | <br/> | ||
| + | |||
| + | NDVI is calculated in Tableau:<br/> | ||
| + | |||
| + | [[File:ShuozhangCalculation.JPG|350px]] | ||
Latest revision as of 22:19, 15 July 2017
|
|
|
|
|
Opting out the data files
The data from 2014-11-28 and 2015-11-15 has been removed from the analytics process because the weather on that two days are extremely cloudy and the sensor can not detect anything due to that all the band waves cannot penetrate the clouds.
The images for those days are as the follows:
| 2014-11-28: | 2015-11-15: |
|---|---|
 |
 |
Choosing the data files to compare
Since the apparent differences in brightness can occur between dates due to changes in sun angle and atmospheric conditions and the values of specific pixels can change due to a number of factors including Clouds, Atmospheric conditions and etc.
Therefore, the data of the dates that are relatively close in different years are chosen to be analyzed and compared.
At first, a comparison between the images in March is attempted.
Although it was a little bit cloudy that day, the other areas are quite clear.
| 2016-03-06 |
|---|
 |
However, when comparing the NDVI values, the images are too blur to drive any conclusions.
Thus, only the images in June and September of 2015 and 2016 are compared respectively.
Combining the Data Sets
After deciding which data tables are chosen to compare, a combination of two CSV files is performed in R:
NDVI is calculated in Tableau:
