- 博客(11)
- 收藏
- 关注
原创 Python——selenium爬取学科
import timeimport pandas as pdfrom selenium import webdriverfrom selenium.common.exceptions import TimeoutExceptionfrom selenium.webdriver.common.by import Byfrom selenium.webdriver.support.wait ...
2019-03-19 21:07:30 929
转载 Python——多线程
import timeimport threading def f0(): pass def f1(a1,a2): time.sleep(5) f0() t= threading.Thread(target=f1,args=(111,112))#创建线程t.setDaemon(True)#设置为后台线程,这里默认是False,设置为True之后则主线程...
2019-03-10 18:06:13 73
原创 Python,Excel——筛选
import pandas as pdimport numpy as npdata = pd.read_excel("C:/Users/Administrator/Desktop/19_初中_秋续寒.xlsx")nrow= data.shape[0]#print(nrow)#print(data.values[0][1])result=[]#a筛选的限定条件#a=[0,15,2...
2019-03-08 18:11:39 6508
原创 Excel——my_detial()
VBA中字符换行显示需要使用换行符来完成。下面是常用的换行符'chr(10) 可以生成换行符'chr(13) 可以生成回车符'vbcrlf 换行符和回车符'vbCr 等同于chr(10)'vblf 等同于chr(13)'例:Sub test3()MsgBox “我爱” & Chr(10) & “Excel精英培训”’ MsgBox “我爱你” & Chr(...
2019-03-07 19:29:32 118
原创 Excel——my_rank()
Function my_rank(n1 As Integer, n2 As Integer) As Integer Dim s, i As Integer Dim flag As Integer Dim arr() As Integer ReDim arr(n2) For j = 1 To n2 s = 0 ...
2019-03-07 16:33:57 238
原创 Excel——my_section(分数划分级别)
Function my_section(n1 As String, n2 As Integer) As Integer Dim s, i, a, b, c, d, e, f As Integer Dim flag As Integer Dim arr() As Integer ReDim arr(10000) For j = 1 To n...
2019-03-07 16:17:39 252
原创 Python——数据分析
Dataframe:数据帧Dataframe VS Excel一个DataFrame相当于一个Excel的sheet#创建一个空Excel import panda as pd df = pd.DataFrame() df.to_excel("D:/2019.上/3月/output.xlsx")#在空Excel的表中填充数据 import panda as pd df
2019-03-03 19:10:19 228
原创 Python——爬取校线,专业线
import scrapyimport pandas as pdfrom scrapy.http import Requestfrom third.items import Sch_scoreItemclass SchScoreSpider(scrapy.Spider): name = 'sch_score' allowed_domains = ['gkcx.eol....
2019-03-02 15:56:36 196
原创 Excel——VBA
Function 文本(rng As Range) As StringDim str As String For Each c In rng str = str & Chr(10) & c.Value Next 文本 = Right(str, Len(str) - 1)End Function...
2019-03-01 15:16:57 167
原创 Excel——函数
OFFSET函数详解:=OFFSET(reference,rows,cols,height,width)=OFFSET(参考系或参考区域,向下移动行数,向右移动列数,取值行数,取值列数)Reference:参考系或参考区域Rows:向下移动行数;Cols:向右移动列数;Height:取值行数;Width:取值列数;...
2019-03-01 14:23:33 122
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人