| import multiprocessing
|
| import os
|
| import pandas as pd
|
| import requests
|
| from bs4 import BeautifulSoup
|
| import re
|
| import string
|
| import nltk
|
| import time
|
| nltk.download('punkt')
|
| nltk.download('stopwords')
|
| nltk.download('wordnet')
|
| nltk.download('cmudict')
|
| from nltk.corpus import stopwords
|
| from nltk.tokenize import sent_tokenize, word_tokenize
|
| from nltk.corpus import cmudict
|
|
|
| folderpath = r'C:\Users/suwes/SentimentEngine/'
|
| textfile_path = f"{folderpath}inputtext/"
|
| stopword_path = f"{folderpath}StopWords/"
|
| masterdict_path = f"{folderpath}MasterDictionary/"
|
|
|
| def createdf():
|
| inputxlsx = os.path.join(folderpath, "Input.xlsx")
|
| dfxlsx = pd.read_excel(inputxlsx)
|
| print(dfxlsx)
|
| df_urls = dfxlsx['URL']
|
|
|
| return dfxlsx
|
|
|
| df = createdf()
|
|
|
| def extract(df):
|
|
|
| def extract_urltext(url):
|
| response = requests.get(url)
|
| soup = BeautifulSoup(response.content, 'html.parser')
|
| article_title = soup.find('title').get_text()
|
| article_content = soup.find('div', class_= 'td-pb-span8 td-main-content')
|
| article_text = ''
|
| if article_content:
|
| for para in article_content.find_all(['p', 'h1', 'h2', 'h3', 'h4', 'h5', 'h6']):
|
| article_text += para.get_text()
|
|
|
|
|
| return article_title, article_text
|
|
|
|
|
|
|
|
|
|
|
| for index, row in df.iterrows():
|
| url = row['URL']
|
| url_id = row['URL_ID']
|
| article_title, article_text = extract_urltext(url)
|
|
|
| filename = f"{folderpath}inputtext/{url_id}.txt"
|
| with open(filename, 'w', encoding = 'utf-8') as file:
|
| file.write(article_title+ '\n\n' +article_text)
|
| print(f"text saved to file {filename}")
|
|
|
|
|
| extract(df)
|
|
|
| def transform(df):
|
|
|
|
|
| def read_stopwords(stopword_folder):
|
| stopwords = set()
|
| filenames = os.listdir(stopword_folder)
|
|
|
| for filename in filenames:
|
| filepath = os.path.join(stopword_folder, filename)
|
|
|
| with open(filepath, 'r', encoding= 'utf-8', errors='ignore') as file:
|
| stopwords.update(map(str.strip, file.readlines()))
|
| return stopwords
|
|
|
| stopwords = read_stopwords(stopword_path)
|
|
|
|
|
| def clean_stopwords(text, stopwords):
|
|
|
| words = word_tokenize(text)
|
|
|
| cleaned_words = [word for word in words if word.lower() not in stopwords]
|
|
|
| cleaned_text = ' '.join(cleaned_words)
|
| return cleaned_text
|
|
|
|
|
| def clean_stopwords_directory(directory, stopwords):
|
|
|
| filenames = os.listdir(directory)
|
|
|
| for filename in filenames:
|
| filepath = os.path.join(directory, filename)
|
|
|
| with open(filepath, 'r', encoding='utf-8', errors='ignore') as file:
|
| text = file.read()
|
|
|
| cleaned_text = clean_stopwords(text, stopwords)
|
|
|
| with open(filepath, 'w', encoding= 'utf-8', errors='ignore') as file:
|
| file.write(cleaned_text)
|
| print(f"cleaned text from {filename}")
|
|
|
| clean_stopwords_directory(textfile_path, stopwords)
|
|
|
| def create_posneg_dict(masterdict_path, stopwords):
|
| poswords = set()
|
| negwords = set()
|
|
|
| with open(os.path.join(masterdict_path, 'positive-words.txt'), 'r', encoding='utf-8', errors='ignore') as file:
|
| for line in file:
|
| words = line.strip().split()
|
| for word in words:
|
| if word.lower() not in stopwords:
|
| poswords.add(word.lower())
|
|
|
| with open(os.path.join(masterdict_path, 'negative-words.txt'), 'r', encoding='utf-8', errors='ignore') as file:
|
| for line in file:
|
| words = line.strip().split()
|
| for word in words:
|
| if word.lower() not in stopwords:
|
| negwords.add(word.lower())
|
| return poswords, negwords
|
|
|
| positivewords, negativewords = create_posneg_dict(masterdict_path, stopwords)
|
|
|
|
|
| return stopwords, positivewords, negativewords
|
|
|
|
|
| stopwords, positivewords, negativewords = transform(df)
|
|
|
|
|
| result_df = pd.DataFrame()
|
| def loadoutput(folderpath, result_df):
|
| exceloutfilepath = f"{folderpath}Output.xlsx"
|
| result_df.to_excel(exceloutfilepath, index=False)
|
| print(f"output file saved to {exceloutfilepath}")
|
| print(f"analysis time: {int((time.time() - starttime)//3600)} hours {int(((time.time() - starttime)%3600)//60)} minutes {int((time.time() - starttime)%60)} seconds")
|
|
|
|
|
| def runengine(df, stopwords, files_subset, dflist):
|
|
|
|
|
| def calculate_positivescore(words, positivewords):
|
| positivescore = sum(1 for word in words if word.lower() in positivewords)
|
| return positivescore
|
|
|
| def calculate_negativescore(words, negativewords):
|
| negativescore = (sum(-1 for word in words if word.lower() in negativewords))*(-1)
|
| return negativescore
|
|
|
|
|
| def calc_readibility(words, sentences):
|
|
|
| avg_sentencelen = len(words)/len(sentences) if sentences else 0
|
|
|
| complexwords = [word for word in words if syllable_count(word)>2]
|
| percent_complexwords = len(complexwords)/len(words)*100 if words else 0
|
|
|
| fog_index = 0.4*(avg_sentencelen + percent_complexwords)
|
| return avg_sentencelen, percent_complexwords, fog_index
|
|
|
|
|
| def avg_wordspersentence(words, sentences):
|
| if len(sentences) > 0:
|
| averagewords = len(words)/len(sentences)
|
| return averagewords
|
| else: return 0
|
|
|
|
|
| def syllable_count(word):
|
| d = cmudict.dict()
|
| if word.lower() in d:
|
| return [len(list(y for y in x if y[-1].isdigit())) for x in d[word.lower()]][0]
|
| else:
|
| return 0
|
| def complexwords_count(words):
|
| complexwords = [word for word in words if syllable_count(word)>2]
|
| return len(complexwords)
|
|
|
|
|
| def cleanwords_count(words, stopwords):
|
| punctuations = set(string.punctuation)
|
| cleaned_words = [word.lower() for word in words if word.lower() not in stopwords and word.lower() not in punctuations]
|
| return len(cleaned_words)
|
|
|
|
|
|
|
| def vowel_syllable(word):
|
| vowels = 'aeiouy'
|
| count = 0
|
| endings = 'es', 'ed', 'e'
|
|
|
| word = word.lower().strip()
|
| if word.endswith(endings):
|
| word = word[:-2]
|
| elif word.emdswith('le'):
|
| word = word[:-2]
|
| endings = ''
|
| elif word.endswith('ing'):
|
| word = word[:-3]
|
| endings = ''
|
|
|
| if len(word)<=3:
|
| return 1
|
| for index, letter in enumerate(word):
|
| if letter in vowels and (index ==0 or word[index -1] not in vowels):
|
| count +=1
|
|
|
| if word.endswith('y') and word[-2] not in vowels:
|
| count +=1
|
| return count
|
|
|
| def vowel_syllable_perword(words):
|
| total_syllables = sum(syllable_count(word) for word in words)
|
| return total_syllables
|
|
|
|
|
| def count_pronouns(text):
|
| pattern = r'\b(?:I|we|my|ours|us)\b'
|
|
|
| matches = re.findall(pattern, text, flags=re.IGNORECASE)
|
|
|
| matches_fin = [matches for match in matches if match.lower() != 'us']
|
| countpron = len(matches_fin)
|
| return countpron
|
|
|
|
|
| def calc_avg_wordlength(words):
|
| total_chars = sum(len(word) for word in words)
|
| total_words = len(words)
|
| if total_words != 0:
|
| avg_wordlength = total_chars/total_words
|
| else: avg_wordlength = 0
|
| return avg_wordlength
|
|
|
| def appendtodf(url_idkey, calc_values, process_df):
|
| rowindex = df[df['URL_ID'] == url_idkey].index
|
| if not rowindex.empty:
|
| idx_toupdate = rowindex[0]
|
|
|
| new_row = pd.DataFrame(columns=process_df.columns)
|
|
|
| new_row.loc[0, process_df.columns[:2]] = df.loc[idx_toupdate, ['URL_ID', 'URL']]
|
|
|
| for col, value in calc_values.items():
|
| new_row[col] = value
|
|
|
| process_df = process_df._append(new_row, ignore_index=True)
|
| print(f"Result updated for {url_idkey}")
|
| else:
|
| print(f"!not found {url_idkey}")
|
| return process_df
|
|
|
|
|
| process_df = pd.DataFrame(columns=df.columns)
|
| for filename in files_subset:
|
| filepath = os.path.join(textfile_path, filename)
|
|
|
| url_idkey = re.search(r'blackassign\d{4}', filepath).group()
|
| if os.path.isfile(filepath):
|
| with open(filepath, 'r', encoding='utf-8', errors='ignore') as file:
|
| text = file.read()
|
|
|
| words = word_tokenize(text)
|
| sentences = sent_tokenize(text)
|
| totalwords = len(words)
|
|
|
|
|
| positive_score = calculate_positivescore(words, positivewords)
|
| print(f"{filename} positive socre: {positive_score}")
|
|
|
|
|
| negative_score = calculate_negativescore(words, negativewords)
|
| print(f"{filename} negative socre: {negative_score}")
|
|
|
|
|
| polarity_score = (positive_score - negative_score)/((positive_score+negative_score)+0.000001)
|
| print(f"{filename} polarity socre: {polarity_score}")
|
|
|
|
|
| subjectivity_score = (positive_score+negative_score)/((totalwords)+0.000001)
|
| print(f"{filename} subjectivity socre: {subjectivity_score}")
|
|
|
|
|
| avg_sentencelen, percent_complexwords, fog_index = calc_readibility(words, sentences)
|
| print(f"{filename} avg sentencelength: {avg_sentencelen}")
|
|
|
| print(f"{filename} percentage of complex words: {percent_complexwords}")
|
|
|
| print(f"{filename} Fog Index: {fog_index}")
|
|
|
|
|
| avg_wordper_sentence = avg_wordspersentence(words, sentences)
|
| print(f"{filename} avg words per sentence: {avg_wordper_sentence}")
|
|
|
|
|
| complexword_count = complexwords_count(words)
|
| print(f"{filename} complex words count: {complexword_count}")
|
|
|
|
|
| cleanword_count = cleanwords_count(words, stopwords)
|
| print(f"{filename} clean words count: {cleanword_count}")
|
|
|
|
|
| syllablecount_perword = vowel_syllable_perword(words)
|
| print(f"{filename} syllable count per word: {syllablecount_perword}")
|
|
|
|
|
| pronouns_count = count_pronouns(text)
|
| print(f"{filename} personal pronouns count: {pronouns_count}")
|
|
|
|
|
| avg_wordlength = calc_avg_wordlength(words)
|
| print(f"{filename} avg word length: {avg_wordlength}")
|
| else: print(f"df not updated for {filename}!")
|
|
|
| calc_values = {
|
| "POSITIVE SCORE": positive_score,
|
| "NEGATIVE SCORE": negative_score,
|
| "POLARITY SCORE": polarity_score,
|
| "SUBJECTIVITY SCORE": subjectivity_score,
|
| "AVG SENTENCE LENGTH": avg_sentencelen,
|
| "PERCENTAGE OF COMPLEX WORDS": percent_complexwords,
|
| "FOG INDEX": fog_index,
|
| "AVG NUMBER OF WORDS PER SENTENCE": avg_wordper_sentence,
|
| "COMPLEX WORD COUNT": complexword_count,
|
| "WORD COUNT": cleanword_count,
|
| "SYLLABLE PER WORD": syllablecount_perword,
|
| "PERSONAL PRONOUNS": pronouns_count,
|
| "AVG WORD LENGTH": avg_wordlength
|
| }
|
| try:
|
| process_df = appendtodf(url_idkey,calc_values, process_df)
|
| except Exception as e:
|
| print(e)
|
| print(process_df)
|
| dflist.append(process_df)
|
|
|
|
|
|
|
|
|
| if __name__ == '__main__':
|
| starttime = time.time()
|
| files_toprocess = os.listdir(textfile_path)
|
|
|
| num_processes = multiprocessing.cpu_count()
|
| print(str(num_processes)+ " CPUs")
|
| files_perprocess = len(files_toprocess) // num_processes
|
| print(files_perprocess)
|
|
|
| processes = []
|
|
|
| manager = multiprocessing.Manager()
|
| dflist = manager.list()
|
|
|
| for i in range(num_processes):
|
| try:
|
| start = i*files_perprocess
|
| end = (i+1)*files_perprocess if i != num_processes-1 else len(files_toprocess)
|
| files_subset = files_toprocess[start:end]
|
|
|
| p = multiprocessing.Process(target=runengine, args =(df, stopwords, files_subset, dflist))
|
| processes.append(p)
|
| p.start()
|
| except Exception as e:
|
| print(e)
|
|
|
| print("waiting for all processes to end...")
|
| for i in processes:
|
| print(i)
|
| for process in processes:
|
| try:
|
| process.join()
|
| except Exception as e:
|
| print(e)
|
| for i in processes:
|
| print(i)
|
|
|
| print(str(len(dflist))+" result dataframes obtained.")
|
| result_df = pd.concat(dflist, ignore_index=True)
|
| result_df = result_df.sort_values(by='URL_ID')
|
| print(result_df)
|
|
|
| loadoutput(folderpath, result_df)
|
|
|