# coding: utf-8

# In[167]:

import os
import numpy as nu
import pandas as pd
import collections as ck


# In[168]:

mss=nu.array([12,6,18,10,15,18,16,3,1,15,5,18,6,11])


# In[169]:

nx=(1*sum(mss))/len(mss)
print(nx)


# In[170]:

tabldata=[]
# добавляем массив в список для последующей генирации таблец,
#так как функция arange массив исключая последние значение поэтому +2
tabldata.append(nu.arange (1,len(mss)+2))
tabldata.append(mss)
tabldata.append(nu.sort(mss))


# In[171]:

p=pd.Series(tabldata)


# In[172]:

c={"xi":tabldata[1],"xjp":tabldata[2]}
df= pd.DataFrame(c)
df


# In[173]:

me=df.median()["xjp"]
mo=df.mode()["xjp"]
print("Me=",me)
print("Mo=",mo.max())


# In[174]:

cx3=[ x-nx for x in tabldata[1]  ]
#c={"xi":tabldata[1],"X":nx,
cx4=[x**2 for x in cx3]
cx5=[x**3 for x in cx3]
cx6=[x**4 for x in cx3]

cgen=[mss.tolist(),nx,cx3,cx4,cx5,cx6]
#dfc=pd.concat([
#pd.DataFrame(cgen,columns=["nx","xi-nx","(xi-nx)^2","(xi-nx)^3","(xi-nx)^4"]),
#pd.DataFrame(mss,columns=["xi"])
#])
#dfc
dictsumtbl=ck.OrderedDict()
dcgen= ck.OrderedDict(zip(["x","nx","xi-nx","(xi-nx)^2","(xi-nx)^3","(xi-nx)^4"],cgen))
dcgen2=["(xi-nx)^2","(xi-nx)^3","(xi-nx)^4"]
df2=pd.DataFrame(dcgen)
for z in dcgen2:
    dictsumtbl.update({z:[df2[z].sum()]})
df2=df2.append(pd.DataFrame(dictsumtbl,columns=["(xi-nx)^2","(xi-nx)^3","(xi-nx)^4"]),ignore_index=True)


# In[175]:

dx= df2["(xi-nx)^2"][0]
dx