Difference between revisions of "ISS608 2017-18 T1 Assign KyonghwanKim Data Preparation"
Jump to navigation
Jump to search
Kh.kim.2016 (talk | contribs) (Created page with "file:title.png <div style=background:#B4CE20 border:#D8CBA4> <font size = 6; color="#000000">Vastropolis Epidemic Report</font> </div> <!--MAIN HEADER --> {|style="backgr...") |
Kh.kim.2016 (talk | contribs) |
||
Line 6: | Line 6: | ||
<!--MAIN HEADER --> | <!--MAIN HEADER --> | ||
{|style="background-color:#B4CE20;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | {|style="background-color:#B4CE20;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | ||
− | | style="font-family:Century Gothic; font-size:100%; solid #000000; background:# | + | | style="font-family:Century Gothic; font-size:100%; solid #000000; background:#B4CE20; text-align:center;" width="16.67%" | |
; | ; | ||
[[ISS608_2017-18_T1_Assign_KyonghwanKim| <font color="#000000">Background</font>]] | [[ISS608_2017-18_T1_Assign_KyonghwanKim| <font color="#000000">Background</font>]] | ||
− | | style="font-family:Century Gothic; font-size:100%; solid #D8CBA4; background:# | + | | style="font-family:Century Gothic; font-size:100%; solid #D8CBA4; background:#F18D50; text-align:center;" width="16.67%" | |
; | ; | ||
[[ISS608_2017-18_T1_Assign_KyonghwanKim_Data_Preparation| <font color="#000000">Data Preparation</font>]] | [[ISS608_2017-18_T1_Assign_KyonghwanKim_Data_Preparation| <font color="#000000">Data Preparation</font>]] | ||
Line 33: | Line 33: | ||
|} | |} | ||
<br/> | <br/> | ||
+ | |||
+ | |||
+ | |||
+ | =Microblog= | ||
+ | |||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | |style="text-align:center;" |'''Description''' | ||
+ | |style="text-align:center;" |'''Illustration''' | ||
+ | |- | ||
+ | |'''1. Split of Columns'''<br/> | ||
+ | *Created_at column is splitted to Date and Time columns. Date column is used in other analytics.<br/> | ||
+ | *Also, Location column is splitted to Latitude and Longitude columns. These data is used to plot in Vastropolis map. | ||
+ | |[[file:microblog_split.png]] | ||
+ | |- | ||
+ | |} |