Difference between revisions of "Group 4 Data Prep"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 42: Line 42:
  
 
Summary of number of data rows and variables
 
Summary of number of data rows and variables
''Bitcoin dataframe''
+
<center style="font-size:15px;"> <u>''Bitcoin Data''</u> </center>
 
[Attach image]
 
[Attach image]
  
''Gold dataframe''
+
<center style="font-size:15px;"> <u>''Gold Price Data''</u> </center>
 
[Attach image]
 
[Attach image]
  
''Nasdaq dataframe''
+
<center style="font-size:15px;"> <u>''Nasdaq Index''</u> </center>
 
[Attach image]
 
[Attach image]
  
''SP500 dataframe''
+
<center style="font-size:15px;"> <u>''S&P 500''</u> </center>
 
[Attach image]
 
[Attach image]

Revision as of 11:28, 30 November 2017

Bitcoin.png Group 4 Project - A Tale of Bitcoin

Overview

Data Prep

Design & Built

Report

Poster

R Application

 


Data source and preparation

The following are the data used

  1. Per minute bitcoin price data, extracted from Kaggle: https://www.kaggle.com/mczielinski/bitcoin-historical-data
  2. Nasdaq index: https://finance.yahoo.com/quote/%5EIXIC/history?ltr=1
  3. S&P500: https://finance.yahoo.com/quote/%5EGSPC/history?p=%5EGSPC
  4. Gold Price: https://finance.yahoo.com/quote/%5EXAU/history?p=%5EXAU

Data was easily downloaded from the link above. The bitcoin data downloaded requires data type conversion from UNIX time stamp to the more common YYYY-MM-DD format. The function [as.POSIXct] in base R easily convert the timestamp into the right format. We have also selected to use data from 2012 onwards because there is only 1-month worth of data in 2011. Excluding this data will not substantially affect our analysis. Data date range is from 1st January 2012 to 20th October 2017 The following are screenshots of the original data imported

Summary of number of data rows and variables

Bitcoin Data

[Attach image]

Gold Price Data

[Attach image]

Nasdaq Index

[Attach image]

S&P 500

[Attach image]