import numpy as np
import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt
sns.set()
data_0 = pd.read_csv("19-0.csv")
data_4 = pd.read_csv("19-4.csv")
data_8 = pd.read_csv("19-8.csv")
not_feature = ['ts','run','state','p-1','p-2','p-3','p-4','p-5','c161', 'Unnamed: 0']
feature_columns = [_ for _ in list(data_8.columns) if _ not in not_feature]
w = 10
h = 16
def mergeGrids(data):
#data: df with each state one sensor location
data = data.drop_duplicates(subset='state', keep="last")
data = data[data['state'] != 0 ]
res = np.zeros((h,w))
X = data[feature_columns].values
X = X.reshape((X.shape[0], w, h))
i = 0
for x in range(h):
#print(x)
for y in range(w):
#print(y)
res[x,y] = X[i].T[x,y]
i +=1
return res
grid4 = mergeGrids(data_4)
grid8 = mergeGrids(data_8)
sns.heatmap(grid8)
n = 160 * 13
target = np.empty(n)
x = data_0.loc[0,feature_columns].values.flatten()
plot = {
'0': x,
'4': grid4.flatten(),
'8': grid8.flatten()
}
plotdf = pd.DataFrame(plot)
sns.catplot(data=plotdf, kind="strip")
plotdf[0:10]
0float64
0.0 - 0.0
4float64
0.0 - 770.0
0
0
592
1
0
671
2
0
705
3
0
770
4
0
689
5
0
633
6
0
0
7
0
736
8
0
624
9
0
568
y = plotdf.values.reshape((160*3), order='F')
x = np.repeat([0.01,112,320], 160)
print(x.shape)
print(y.shape)
Execution error
NameError: name 'plotdf' is not defined
sns.regplot(x,y, logx = True);
/shared-libs/python3.7/py/lib/python3.7/site-packages/seaborn/_decorators.py:43: FutureWarning: Pass the following variables as keyword args: x, y. From version 0.12, the only valid positional argument will be `data`, and passing other arguments without an explicit keyword will result in an error or misinterpretation.
FutureWarning
plotdf.T
0float64
1float64
0
0
0
4
592
671
8
680
758
weight0=plotdf.T.iloc[0]
weight4=plotdf.T.iloc[1]
weight8=plotdf.T.iloc[2]
plt.plot(weight0,linestyle=':')
plt.plot(weight4,linestyle=':')
plt.plot(weight8,linestyle=':')