- 博客(11)
- 收藏
- 关注
RSS订阅原创 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
686
转载 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
64
原创 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
6412
原创 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
103
原创 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
226
原创 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
243
原创 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
216
原创 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
176
原创 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
154
原创 Excel——函数
OFFSET函数详解：=OFFSET(reference,rows,cols,height,width)=OFFSET(参考系或参考区域，向下移动行数，向右移动列数，取值行数，取值列数)Reference：参考系或参考区域Rows：向下移动行数；Cols：向右移动列数；Height：取值行数；Width：取值列数；...
2019-03-01 14:23:33
117
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人