chulong-li / real-time-sentiment-tracking-on-twitter-for-brand-improvement-and-trend-recognition Goto Github PK

I am using access keys of my standard product track. I have been trying to do sentiment analysis of real time tweets using this codebase. the script runs perfectly but after around 24 hours my app gets suspended. Twitter send me email with no specific reason behind suspension. I have been searching solution for this for 3 days but in vain. I would appreciate you time.

Hi there,

Apologies if this is a bit of a rookie question/request, I am new to programming and trying to learn as much as I can as I go.

I am having a problem with the Trend_Analysis_Complex.ipynb file, as I keep receiving this error:
(NOTE: I am looking at Corona instead of Facebook which you used in your example and am also trying to scrape in South Africa as opposed to the USA)

KeyError Traceback (most recent call last)
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance)
2896 try:
-> 2897 return self._engine.get_loc(key)
2898 except KeyError:

pandas_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

pandas_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

KeyError: "Num of 'Corona' mentions"

During handling of the above exception, another exception occurred:

KeyError Traceback (most recent call last)
in
38 fig.add_trace(go.Scatter(
39 x=time_series,
---> 40 y=result["Num of '{}' mentions".format(settings.TRACK_WORDS[0])][result['polarity']==0].reset_index(drop=True),
41 name="Neutral",
42 opacity=0.8), row=1, col=1)

~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\frame.py in getitem(self, key)
2978 if self.columns.nlevels > 1:
2979 return self._getitem_multilevel(key)
-> 2980 indexer = self.columns.get_loc(key)
2981 if is_integer(indexer):
2982 indexer = [indexer]

~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance)
2897 return self._engine.get_loc(key)
2898 except KeyError:
-> 2899 return self._engine.get_loc(self._maybe_cast_indexer(key))
2900 indexer = self.get_indexer([key], method=method, tolerance=tolerance)
2901 if indexer.ndim > 1 or indexer.size > 1:

pandas_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

pandas_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

KeyError: "Num of 'Corona' mentions"

hey, first of all this is a great notebook, thanks for putting this together :D
So I set all credentials, set up a local mysql db and tried to run the Main jupyter notebook file. All cells ran great without any issue: checked mysql workbench and the table was created with columns under twitterDB, only thing is - no data.
The cell with:
`class Stream(tweepy.Stream):
def on_status(self, status):
print(status.text)
Stream = Stream()
myStream = tweepy.Stream()
myStream.filter (languages=['en'], track = settings.TRACK_WORDS)
is filled with the access keys and tokens, and keep on running but no data at all appears in my local db.
I also checked my twitter app and saw no requests were made out of my monthly tweet cap usage bar (elevated subscription).
Can anyone assist please?

What is Back_Up table in line 145 app.py file in dash_app folder. How to add data in this table.