#!/usr/bin/python
# -*- coding:UTF-8 -*-
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import operator
df = pd.read_table('newdata.txt',header=None,sep=',')
tdate = sorted(df.loc[:,0])
# print tdate
h1 = df.loc[:,1:7:6].values  #取第一列紅球和藍球
# print h1
h2 = df.loc[:,2:7:5].values  #取第二列紅球和藍球
h3 = df.loc[:,3:7:4].values
h4 = df.loc[:,4:7:3].values
h5 = df.loc[:,5:7:2].values
h6 = df.loc[:,6:7:1].values
# tblue = df.loc[:,7]
#將上方切分的所有數據組合到一起
data = np.append(h1, h2, axis = 0)
data = np.append(data, h3, axis = 0)
data = np.append(data, h4, axis = 0)
data = np.append(data, h5, axis = 0)
data = np.append(data, h6, axis = 0)
# print data
data1 = pd.DataFrame(data)
# print data1
#寫入到一個文件中
data1.to_csv('hldata.csv',index=None,header=None)
#讀取文件，將組合進行統(tǒng)計并從大到小排序
f = open("hldata.csv")
count_dict = {}
for line in f.readlines():
  line = line.strip()
  count = count_dict.setdefault(line, 0)
  count += 1
  count_dict[line] = count
sorted_count_dict = sorted(count_dict.iteritems(), key=operator.itemgetter(1), reverse=True)
# for item in sorted_count_dict:
#   print "%s,%d" % (item[0], item[1])
# print sorted_count_dict
fenzu = pd.DataFrame(sorted_count_dict).set_index([0])
#print fenzu
#分別從第一列和第二列取前19個數據放到x y中
x = list(fenzu.index[:19])
y = list(fenzu.values[:19])
print x
print y
#將x對應數值，不然畫圖報錯
s = pd.Series(range(1,len(x)+1), index=x)
#設置畫圖屬性
plt.figure(figsize=(12,6),dpi=80)
plt.legend(loc='best')
# plt.plot(fenzu,color='red')
plt.bar(s,y,alpha=.5, color='r',width=0.8)
plt.title('The one red and one blue ball number')
plt.xlabel('one red and one blue number')
plt.ylabel('times')
#可以在圖中放置標簽字符
# for i in range(0,19):
#   plt.text(int(i+1.4),25,x[i],color='b',size=10)
# plt.text(1.4,20,x[0],color='g',ha='center')
#將['1,12', '26,9', '5,13']這樣的字符放到圖中
plt.xticks(s,x, rotation=10,size=10,ha='left')
plt.show()

import matplotlib.pyplot as plt
import numpy as np
plt.rc('font', family='SimHei', size=13)
num = np.array([13325, 9403, 9227, 8651])
ratio = np.array([0.75, 0.76, 0.72, 0.75])
men = num * ratio
women = num * (1-ratio)
x = ['聊天','支付','團購\n優(yōu)惠券','在線視頻']
width = 0.5
idx = np.arange(len(x))
plt.bar(idx, men, width, color='red', label='男性用戶')
plt.bar(idx, women, width, bottom=men, color='yellow', label='女性用戶')
plt.xlabel('應用類別')
plt.ylabel('男女分布')
plt.xticks(idx+width/2, x, rotation=40)
plt.legend()