2018年01月_孤舟听雨

12月 11月 09月 08月 07月 06月 05月 04月 03月 02月 01月

原创 python 线损率计算

# encoding=utf-8import numpy as npimport pandas as pd# 线损率属性构造# 参数初始化# 供入供出电量数据inputfile = 'data/electricity_data.xls'outputfile = 'data/electricity_data_out.xls'# 读入数据data = pd.read_ex

2018-01-28 15:56:40 844

原创 python 离散化与面元划分

# encoding=utf-8import numpy as npimport pandas as pd### 离散化与面元划分# 1ages = [20, 22, 25, 27, 21, 23, 37, 31, 61, 45, 41, 32]bins = [18, 25, 35, 60, 100]cats = pd.cut(ages, bins)# print 'cats:=

2018-01-28 15:40:31 826

原创 python 移除重复数据

# encoding=utf-8# 移除重复数据import pandas as pdimport numpy as npdata = pd.DataFrame({ 'k1': ['one'] * 3 + ['two'] * 4, 'k2': [1, 1, 2, 3, 3, 4, 4]})# print 'data:=\n', data# print 'data.

2018-01-27 18:49:31 2075

原创轴向连接和层次化索引

# encoding=utf-8import numpy as npimport pandas as pd# 轴向连接# 1arr = np.arange(12).reshape((3, 4))print 'arr:=\n', arrarr_concatenate_arr = np.concatenate([arr, arr], axis=1)# 2s1 = pd.Serie

2018-01-27 14:47:57 182

原创 python 数据分析种，长宽格式的转换

# encoding=utf-8import numpy as npimport pandas as pd# 长宽格式的转换# 1data = pd.read_csv('d:data/macrodata.csv')print 'data:=\n', dataprint 'data.to_records():=\n', data.to_records()print 'data.

2018-01-27 14:46:00 2787 1

原创多表连接与轴向连接

# -*- coding: utf-8 -*-# encoding=utf-8from __future__ import divisionimport numpy as npimport xlwtimport os# 导入matplot 函数import matplotlib.pyplot as matplot_pyplot# 导入拉格朗日插值函数from scipy.

2018-01-27 14:44:59 250

原创 numpy.convolve 用法

In [24]: a=[1,2]In [25]: b=[1,2]In [26]: np.convolve(a,b) Out[26]: array([1, 4, 4])是用a*b[0] 得到[1,2] 再用a*b[1] 得到[0,2,4] ,注意，此处要根据b 的索引进行0的补充。然后对应位置进行相加。

2018-01-25 14:52:27 4939

原创 python 操作excel

# encoding=utf-8import xlrd, xlwtimport pandas as pdimport syspath = 'd:data/'# 从工作簿中读取book = xlrd.open_workbook(path + 'workbook.xls')print 'book:=\n', bookprint 'book.sheet_names():=', boo

2018-01-23 22:51:07 397 1

原创 python 操作json

# encoding=utf-8import numpy as npimport pandas as pdimport json# JSON 数据obj = """{ "name":"Wes", "places_lived":["United States","Germany"], "pet":null, "siblings": [

2018-01-23 22:49:54 1075

原创 python request 获取网络数据

# encoding=utf-8import requestsimport jsonimport pandas as pdurl = 'https://api.github.com/repos/pydata/pandas/milestones/28/labels'resp = requests.get(url)print 'resp:=\n', respdata = json.lo

2018-01-23 22:49:24 2405

原创 python sqlite

# encoding=utf-8import sqlite3import pandas as pdquery = """CREATE TABLE test(a VARCHAR(20),b VARCHAR(20),c REAL ,d INTEGER );"""con = sqlite3.connect(':memory')con.execute(query)data

2018-01-23 22:48:33 221

原创 pandas 轴向连接

# encoding=utf-8import numpy as npimport pandas as pd# 轴向连接# 1arr = np.arange(12).reshape((3, 4))print 'arr:=\n', arrarr_concatenate_arr = np.concatenate([arr, arr], axis=1)# 2s1 = pd.Serie

2018-01-23 22:47:32 316

原创 python pandas.DataFrame 数据合并

2018-01-20 16:59:48 3108

原创 python 数据清洗学习笔记

缺失值处理 —删除记录 —数据插补 —–拉格朗日插值法、牛顿插值法 —不处理查补方法方法描述均值/中位数/众数查补根据属性值的类型，用该属性值的

2018-01-16 21:37:52 403

原创 numpy 学习笔记 8

# encoding=utf-8import numpy as npimport pandas as pdimport json# JSON 数据obj = """{ "name":"Wes", "places_lived":["United States","Germany"], "pet":null, "siblings": [

2018-01-15 22:47:24 229

原创 python 操作Excel 学习笔记

# encoding=utf-8import numpy as npimport pandas as pdimport sysimport xlrd, xlwtpath = 'd:data/'wb = xlwt.Workbook()print wbwb.add_sheet('first_sheet', cell_overwrite_ok=True)wb.get_active_s

2018-01-13 21:47:41 556

转载 python 的zip 函数

原文地址： https://www.cnblogs.com/frydsh/archive/2012/07/10/2585370.htmlzip函数接受任意多个（包括0个和1个）序列作为参数，返回一个tuple列表。具体意思不好用文字来表述，直接看示例：1.示例1：复制代码 x = [1, 2, 3]y = [4, 5, 6]z = [7, 8, 9]xyz = zip(

2018-01-13 16:15:08 118

原创 numpy 学习笔记7

# encoding=utf-8import numpy as npimport pandas as pdimport sys### 数据读取# 读取文本格式数据df = pd.read_csv('d:../data/ex1.csv')print 'df:\n', dfpt = pd.read_table('d:../data/ex1.csv', sep=',')print

2018-01-13 15:53:42 183

原创 pandas 框架数据处理学习笔记1

# encoding=utf-8# Series# 数组与标签# 可以通过标签选取数据# 定长的有序字典# Dataframe# 表格型数据结构# 行索引、列索引import numpy as npimport pandas as pd###pandas# Seriesobj = pd.Series([4,

2018-01-09 22:52:13 295

转载 selected 操作

转载自： http://blog.csdn.net/ch5256865/article/details/48265313js 获取select的值 / js动态给select赋值转载 2015年09月07日 14:37:49 标签：select /赋值 23528 jQuery获取Select选择的Text和Value: 语法解释： 1. (“#select_id”).change

2018-01-09 13:11:05 428

原创 numpy 学习笔记6

测试数据： AAPL,28-01-2011, ,344.17,344.4,333.53,336.1,21144800 AAPL,31-01-2011, ,335.8,340.04,334.3,339.32,13473000 AAPL,01-02-2011, ,341.3,345.65,340.98,345.03,15236800 AAPL,02-02-2011, ,344.45,345.

2018-01-08 22:17:21 245

原创 numpy 学习笔记5

# encoding=utf-8import numpy as npfrom datetime import datetimedef datestr2num(s): return datetime.strptime(s, "%d-%m-%Y").date().weekday()# print datestr2num('12-12-1223')dates, close =

2018-01-07 22:05:38 148

原创 numpy 学习笔记4

encoding=utf-8利用numpy 进行历史股价分析import numpy as np import sys读入文件c, v = np.loadtxt(‘data.csv’, delimiter=’,’, usecols=(4, 6), unpack=True) print ‘c=’, c print ‘v=’, v计算成交量加权平均价格vwap

2018-01-07 16:38:07 367

原创 numpy 函数diff 用法初探

encoding=utf-8# 导入numpy 模块 import numpy as np随机生成一个4行，6列的数组a = np.random.randn(4, 6) print a print ‘\n’ print np.diff(a) print ‘test’ 打印结果如下 [[-1.71410282 0.12532478 0.45723509 0.543

2018-01-04 21:27:24 9029