Difference between revisions of "APA Final Progress"
Line 222: | Line 222: | ||
|style="vertical-align:top;width:30%;" | <div style="background: #10d0e5; padding: 13px; font-weight: bold; text-align:center; line-height: wrap_content; text-indent: 20px;font-size:20px; font-family:helvetica"> <font color= #ffffff>Data Exploration</font></div><br/> | |style="vertical-align:top;width:30%;" | <div style="background: #10d0e5; padding: 13px; font-weight: bold; text-align:center; line-height: wrap_content; text-indent: 20px;font-size:20px; font-family:helvetica"> <font color= #ffffff>Data Exploration</font></div><br/> | ||
<p> | <p> | ||
+ | <big>'''Email Data exploration'''</big><br> | ||
'''Email distribution for associates'''<br> | '''Email distribution for associates'''<br> | ||
Every Bubble indicates number of emails sent by an employee on a single day. The size represents the number of emails for the day. It can be observed that most associates seem to have regular email communication. It can also be observed that Bersileus, Hansel and Lemuel hardly have any communication. This is because they are new to the company. <br> | Every Bubble indicates number of emails sent by an employee on a single day. The size represents the number of emails for the day. It can be observed that most associates seem to have regular email communication. It can also be observed that Bersileus, Hansel and Lemuel hardly have any communication. This is because they are new to the company. <br> | ||
Line 227: | Line 228: | ||
'''Email distribution for the C-Suite'''<br> | '''Email distribution for the C-Suite'''<br> | ||
Every bubble indicates number of emails sent by an employee on a single day. The size represents the number of emails for the day. It can be observed that all C-Suite employees seem to have regular email communication. The instances of huge bubbles are possibly instances of mass emails sent to the company by the C-suite employees.<br> | Every bubble indicates number of emails sent by an employee on a single day. The size represents the number of emails for the day. It can be observed that all C-Suite employees seem to have regular email communication. The instances of huge bubbles are possibly instances of mass emails sent to the company by the C-suite employees.<br> | ||
− | [[Image:csuite.png|300px]] | + | [[Image:csuite.png|300px]]<br> |
'''Average size of email by Hierarchy'''<br> | '''Average size of email by Hierarchy'''<br> | ||
− | Size of an email is a potential indicator of the amount of email content. Figure 10 below shows who sends the largest emails among different hierarchies. Associates seem to have the highest email size. This can be explained by their relatively more hands-on technical work which involves a lot of data. Operational has lowest size to their independent nature and role at the company. | + | Size of an email is a potential indicator of the amount of email content. Figure 10 below shows who sends the largest emails among different hierarchies. Associates seem to have the highest email size. This can be explained by their relatively more hands-on technical work which involves a lot of data. Operational has lowest size to their independent nature and role at the company. <br> |
− | [[Image:hier.png|300px]] | + | [[Image:hier.png|300px]]<br><br> |
− | <big>'''Centralities Without Edge Weights'''</big> | + | <big>'''Centralities Without Edge Weights'''</big><br> |
'''Eigenvector and Betweenness Centrality''' | '''Eigenvector and Betweenness Centrality''' | ||
social network was created using email data where the edges had no weights. Eigenvector and betweenness centrality were applied to this network as visible in the figure below. <br> | social network was created using email data where the edges had no weights. Eigenvector and betweenness centrality were applied to this network as visible in the figure below. <br> |
Revision as of 14:36, 22 April 2017
Data Email Data
Cleaning Email Data
4. Removing unnecessary columns such as:
After the cleaning of data, there were 29,797 rows of data with no missing data instances.
Staff and Email Data Comparison
Cleaning survey data
|