/
data-csv-generator.py
169 lines (157 loc) · 5.65 KB
/
data-csv-generator.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
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
import pandas as pd
import re
import string
import unidecode
lis1 = pd.read_csv('Input Files/Comment Classification/train.csv')
lis2 = pd.read_csv('Input Files/Toxicity Severity/validation_data.csv')
lis1['compound'] = lis1.sum(axis=1)
def pos(x):
if x > 0:
return 1
else:
return 0
lis1['y'] = lis1['compound'].apply(lambda x: pos(x))
lis1 = lis1[['comment_text', 'y']]
less_arr = pd.DataFrame(lis2['less_toxic']).rename(columns={'less_toxic': 'comment_text'}, inplace=False)
more_arr = pd.DataFrame(lis2['more_toxic']).rename(columns={'more_toxic': 'comment_text'}, inplace=False)
more_arr['y'] = 1
less_arr['y'] = 0
lis1 = pd.concat([less_arr, more_arr, lis1])
contractions_dict = {
"ain't": "am not / are not / is not / has not / have not",
"aren't": "are not / am not",
"can't": "cannot",
"can't've": "cannot have",
"'cause": "because",
"could've": "could have",
"couldn't": "could not",
"couldn't've": "could not have",
"didn't": "did not",
"doesn't": "does not",
"don't": "do not",
"hadn't": "had not",
"hadn't've": "had not have",
"hasn't": "has not",
"haven't": "have not",
"he'd": "he had / he would",
"he'd've": "he would have",
"he'll": "he shall / he will",
"he'll've": "he shall have / he will have",
"he's": "he has / he is",
"how'd": "how did",
"how'd'y": "how do you",
"how'll": "how will",
"how's": "how has / how is / how does",
"I'd": "I had / I would",
"I'd've": "I would have",
"I'll": "I shall / I will",
"I'll've": "I shall have / I will have",
"I'm": "I am",
"I've": "I have",
"isn't": "is not",
"it'd": "it had / it would",
"it'd've": "it would have",
"it'll": "it shall / it will",
"it'll've": "it shall have / it will have",
"it's": "it has / it is",
"let's": "let us",
"ma'am": "madam",
"mayn't": "may not",
"might've": "might have",
"mightn't": "might not",
"mightn't've": "might not have",
"must've": "must have",
"mustn't": "must not",
"mustn't've": "must not have",
"needn't": "need not",
"needn't've": "need not have",
"o'clock": "of the clock",
"oughtn't": "ought not",
"oughtn't've": "ought not have",
"shan't": "shall not",
"sha'n't": "shall not",
"shan't've": "shall not have",
"she'd": "she had / she would",
"she'd've": "she would have",
"she'll": "she shall / she will",
"she'll've": "she shall have / she will have",
"she's": "she has / she is",
"should've": "should have",
"shouldn't": "should not",
"shouldn't've": "should not have",
"so've": "so have",
"so's": "so as / so is",
"that'd": "that would / that had",
"that'd've": "that would have",
"that's": "that has / that is",
"there'd": "there had / there would",
"there'd've": "there would have",
"there's": "there has / there is",
"they'd": "they had / they would",
"they'd've": "they would have",
"they'll": "they shall / they will",
"they'll've": "they shall have / they will have",
"they're": "they are",
"they've": "they have",
"to've": "to have",
"wasn't": "was not",
"we'd": "we had / we would",
"we'd've": "we would have",
"we'll": "we will",
"we'll've": "we will have",
"we're": "we are",
"we've": "we have",
"weren't": "were not",
"what'll": "what shall / what will",
"what'll've": "what shall have / what will have",
"what're": "what are",
"what's": "what has / what is",
"what've": "what have",
"when's": "when has / when is",
"when've": "when have",
"where'd": "where did",
"where's": "where has / where is",
"where've": "where have",
"who'll": "who shall / who will",
"who'll've": "who shall have / who will have",
"who's": "who has / who is",
"who've": "who have",
"why's": "why has / why is",
"why've": "why have",
"will've": "will have",
"won't": "will not",
"won't've": "will not have",
"would've": "would have",
"wouldn't": "would not",
"wouldn't've": "would not have",
"y'all": "you all",
"y'all'd": "you all would",
"y'all'd've": "you all would have",
"y'all're": "you all are",
"y'all've": "you all have",
"you'd": "you had / you would",
"you'd've": "you would have",
"you'll": "you shall / you will",
"you'll've": "you shall have / you will have",
"you're": "you are",
"you've": "you have"
}
contractions_re = re.compile('(%s)' % '|'.join(contractions_dict.keys()))
def expand_contractions(text, contractions_dict1=contractions_dict):
def replace(match):
return contractions_dict1[match.group(0)]
return contractions_re.sub(replace, text)
lis1['comment_text'] = lis1['comment_text'].apply(lambda x: expand_contractions(x))
lis1['comment_text'] = lis1['comment_text'].str.lower()
lis1['comment_text'] = lis1['comment_text'].apply(lambda x: re.sub('[%s]' % re.escape(string.punctuation), '', x))
lis1['comment_text'] = lis1['comment_text'].apply(lambda x: re.sub('\w*\d\w*', '', x))
lis1[lis1['y'] >= 0].hist()
lis1 = pd.concat([lis1[lis1['y'] > 0], lis1[lis1['y'] == 0].sample(int(len(lis1[lis1['y'] > 0]) * 1.5))], axis=0).sample(frac=1)
lis1[lis1['y'] >= 0].hist()
lis1['comment_text'] = lis1['comment_text'].apply(lambda x: unidecode.unidecode(x))
lis1['y'] = lis1['y'].astype(str)
lis1['y'] = lis1['y'].apply(lambda x: x.replace('0.0', '0'))
lis1['y'] = lis1['y'].apply(lambda x: x.replace('1.0', '1'))
lis1 = lis1.dropna()
# save the data
lis1.to_csv('Data.csv', index=False)