-
Notifications
You must be signed in to change notification settings - Fork 0
/
part3_analysis.py
81 lines (57 loc) · 3.06 KB
/
part3_analysis.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
# -*- coding: utf-8 -*-
"""
Created on Wed Feb 21 09:43:19 2018
@author: velmurugan.m
"""
import pandas as pd
import numpy as np
###############################################################################
def analyzeGUID(p2GUID, p3GUID, p4TarGUID, p4HostGUID):
#### Get the Entry Count for specific GUIDs from Part-2 & Part-3
arrTarCntList = p4TarGUID[p2GUID]
arrHosCntList = p4HostGUID[p2GUID]
###############################################################################
def part2Analysis():
Loc2 = r'D:\ATT\newData\p2\oem_metrics.csv'
oemMetricDF = pd.read_csv(Loc2)
#### Get the Labels for Part 3 of the Data Series
oemMetricColLabels = oemMetricDF.columns.values
#### Get the GUID Unique values for Part 2 of the Data Series
oemMetricTarGUIDUniq = oemMetricDF.target_guid.unique()
#### Get the GUID values for Part 2 of the Data Series
oemMetricTarGUID = oemMetricDF.target_guid
return oemMetricTarGUID
###############################################################################
def part3Analysis():
Loc3 = r'D:\ATT\newData\p3\oem_metrics_details.csv'
oemMetricDetailsDF = pd.read_csv(Loc3)
#### Get the Labels for Part 3 of the Data Series
oemMetricDetColLabels = oemMetricDetailsDF.columns.values
#### Get the GUID Unique values for Part 3 of the Data Series
oemMetricDetTarGUIDUniq = oemMetricDetailsDF.target_guid.unique()
#### Get the GUID values for Part 3 of the Data Series
oemMetricDetTarGUID = oemMetricDetailsDF.target_guid
return oemMetricDetTarGUID
###############################################################################
def part4Analysis():
Loc4 = r'D:\ATT\newData\p4\oem_target_details.csv'
oemTargetDetailsDF = pd.read_csv(Loc4)
#### Get the Target Labels for Part 4 of the Data Series
oemTargetDetColLabels = oemTargetDetailsDF.columns.values
oemTargetDetTarGUIDUniq = oemTargetDetailsDF.target_guid.unique()
oemTargetDetHostGUIDUniq = oemTargetDetailsDF.host_target_guid.unique()
#### Get the Target GUID Value Counts for Part 4 of the Data Series
oemTargetDetTarGUIDValCounts = oemTargetDetailsDF.target_guid.value_counts()
oemTargetDetHostGUIDValCounts = oemTargetDetailsDF.host_target_guid.value_counts()
#### Get the Target + Host GUID Columns for Part 4 of the Data Series
oemTargetDetTarGUID = oemTargetDetailsDF.target_guid
oemTargetDetHostGUID = oemTargetDetailsDF.host_target_guid
return (oemTargetDetTarGUIDValCounts, oemTargetDetHostGUIDValCounts)
###############################################################################
def main():
p2GUID = part2Analysis()
#p3GUID = part3Analysis()
#p4TarGUIDValCnts, p4HostGUIDValCnts = part4Analysis()
#analyzeGUID( p2GUID, p3GUID, p4TarGUIDValCnts, p4HostGUIDValCnts )
if __name__ == "__main__":
main()