merged data

[stalkermustang]

Hi! Were i can find 'merged_data.csv' for ipynb usage (data = pd.read_csv("merged_data.csv"))?

[jdesrosiers01]

This is confusing for me two.

[aymanapatel]

Same here

[bitsnaps]

I'm digging right there, until now it seems to be both files live_bitcion.csv & live_tweet.csv combined all together if @llSourcell can confirm that? guys remove twilio API if you don't need the SMS alert.

[tonywangcn]

combine sentiment6.txt and bitcoinprices.txt to merged_data.csv. Tried and sucessed.

[stalkermustang]

Hmm, i think we can merge live_bitcion.csv & live_tweet.csv by data(last) column and have 3 cols: price, sentiment, data.

[bitsnaps]

@tonywangcn, thanks, however looking at engine.py there are 3 columns : Price,Sentiment,Time datag = data[['Price','Sentiment']].groupby(data['Time']).mean() combining those 2 files we got 2 column starting from: 20171114,0.38021943904690936 20171113,0.38021943904690936 have you used pandas's join() or something like that ? comparing this fork to the original one, almost no difference!

[bitsnaps]

merge_data.csv can be generated by something like this:

import pandas as pd
btc = pd.read_csv('bitcoinprices.txt')
btc.columns = ["Time","Price"]
sent = pd.read_csv('sentiment6.txt')
sent.columns = ["Time","Sentiment"]
merged = sent.merge(btc, left_index=False, right_index=False, how="inner")
merged.to_csv('merged_data.csv')