In [ ]:
%matplotlib inline
In [ ]:
import pandas as pd
In [ ]:
nd = pd.read_excel('nicki_data.xlsx')
In [ ]:
nd.head()
In [ ]:
nd['q1.2'].hist()
In [ ]:
nd.columns
In [ ]:
drop_columns = [column for column in nd.columns if 'spec' in column]
In [ ]:
print(drop_columns)
In [ ]:
nd = nd.drop(drop_columns, axis=1);
In [ ]:
nd.head()
In [ ]:
nd['q1.1'].hist()
In [ ]:
from pandas.tools.plotting import scatter_matrix
In [ ]:
p = scatter_matrix(nd.loc[:, use_col[:3]], alpha=0.2, figsize=(18, 12), diagonal='kde')
In [ ]:
%%script bash --bg --out script_out
bokeh-server
In [ ]:
nd.dtypes[:5]
In [ ]:
use_col = [True if dtype in ['int64', 'float64'] else False for dtype in nd.dtypes]
In [ ]:
from bokeh.crossfilter.models import CrossFilter
from bokeh.sampledata.autompg import autompg
from bokeh.document import Document
from bokeh.session import Session
from bokeh.plotting import *
app = CrossFilter.create(df=nd.loc[:, use_col])
document = Document()
session = Session()
session.use_doc('crossfilter')
session.load_document(document)
In [ ]:
document.add(app)
session.store_document(document)
session.show(app)
not tested...
writer = pd.ExcelWriter('nd_out.xlsx')
nd.to_excel(writer,'Sheet1')
writer.save()
In [ ]:
nd.to_csv('nd_out.csv')