ugis22 / analysing_twitter Goto Github PK

#Importing postgres credentials
from postgres_credentials import *

#Importing twitter credentials
from twitter_credentials import *

what is for the code above? In my JupyterLab I get the error " No module named 'postgres_credentials' "

Thank you

Dear ugis22,

thank you for all your effort and for sharing your code with us. Unfortunately, a lot of files and information seems to be missing. Next to the mask.png I miss the part where you run the sentiment analysis. Because of that, of course, I can't run the different word_cloud.

Analysis of Twitter
word_cloud(pd.Series([t for t in tweet_table[tweet_table.sentiment == "Positive"].tweet]).str.cat(sep=' '))
AttributeError: 'DataFrame' object has no attribute 'sentiment'

May you provide the missing files, or improve the instruction a bit.

Thank you very much.

`
---------------------------------------------------------------------------
ModuleNotFoundError                       Traceback (most recent call last)
<ipython-input-1-4a9ab2317030> in <module>
      4 
      5 #Importing postgres credentials
----> 6 from postgres_credentials import *
      7 
      8 #Importing twitter credentials

ModuleNotFoundError: No module named 'postgres_credentials'
`

Would be great if you could add examples of the files, so everybody knows the strucutre.
Thank you.

I tried running this code, I have my postgres and twitter credentials in a seperate python....so I ran data streaming notebook and it worked fine without giving any errors...twitter extraction stopped when my connection broke...after that I used cleaning_db but when I run delete_rows function on my table....the cell keeps on running and it doesn't reach to it's completion...What can be the possible reason for this ?

.

Dear ugis22,

thank you very much for your work. I try to follow but I have a question in mind.
So far I understood, you listen to Twitter API and every new Tweet as from interaction or from keyword goes into table predict. In Database clean etc. you use both tables. So I would assume that you have filled tweets_* beforehand. This script is missing in here, right?
Why did you separate the two tables?

Thanks