1、远程连接

python远程操作服务器 - cherry小樱桃 - 博客园

Python3 SSH远程连接服务器_qy20115549的博客-CSDN博客_python3 ssh

安装paramiko模块填坑过程记录_byf0521hlyp的博客-CSDN博客

 pip3 install Twisted

2、文件上传下载

转 -- 使用python的paramiko模块实现ssh与scp功能_edwzhang的专栏-CSDN博客_paramiko scp

3、读取文件

python读取日志，存入mysql_无知而狂妄-CSDN博客_python 将日志写入数据库

正则匹配

  

   

    

     

    
    

     

      line = "::1 - - [19/Mar/2017:20:19:02 +0800] \"GET /favicon.ico HTTP/1.1\" 404 209"
     
    
   

    

     

    
    

     

      patt = r'.*\d\d/\w{3}/\d{4}:\d\d:\d\d:\d\d.*'
     
    
   

    

     

    
    

     

      pattern = re.compile(patt)
     
    
   

    

     

    
    

     

      result = pattern.findall(line)
     
    
   

    

     

    
    

     

      print(result)
     
    
  
 

4、excel操作－Xlwings

Python3-xlwings库使用_MonaLai的博客-CSDN博客_python3 xlwings

https://www.jianshu.com/p/18b63172de6e

::1 - - [06/Aug/2016:20:08:28 +0800] "GET /info.php HTTP/1.1" 200 90503
::1 - - [06/Aug/2016:20:23:22 +0800] "GET /info.php HTTP/1.1" 200 90503
::1 - - [06/Aug/2016:20:23:24 +0800] "GET /info.php HTTP/1.1" 200 90503
::1 - - [06/Aug/2016:20:23:32 +0800] "GET /info.php HTTP/1.1" 200 90502
::1 - - [08/Aug/2016:21:58:33 +0800] "GET /info.php HTTP/1.1" 200 89574
::1 - - [08/Aug/2016:23:09:40 +0800] "GET /phptest/index.php?XDEBUG_SESSION_START=netbeans-xdebug HTTP/1.1" 200 9
::1 - - [08/Aug/2016:23:09:56 +0800] "GET /phptest/index.php?XDEBUG_SESSION_START=netbeans-xdebug HTTP/1.1" 200 9
::1 - - [08/Aug/2016:23:09:58 +0800] "GET /phptest/index.php?XDEBUG_SESSION_START=netbeans-xdebug HTTP/1.1" 200 9
::1 - - [08/Aug/2016:23:10:00 +0800] "GET /phptest/index.php?XDEBUG_SESSION_START=netbeans-xdebug HTTP/1.1" 200 9
::1 - - [08/Aug/2016:23:11:35 +0800] "GET /phptest/index.php?XDEBUG_SESSION_START=dbgp HTTP/1.1" 200 9
::1 - - [08/Aug/2016:23:20:00 +0800] "GET /phptest/index.php?XDEBUG_SESSION_START=dbgp HTTP/1.1" 200 9
::1 - - [08/Aug/2016:23:20:13 +0800] "GET /phptest/index.php?XDEBUG_SESSION_START=xdebug HTTP/1.1" 200 9
::1 - - [08/Aug/2016:23:22:55 +0800] "GET /info.php HTTP/1.1" 200 89574
::1 - - [24/Aug/2016:21:23:01 +0800] "GET / HTTP/1.1" 200 45
::1 - - [24/Aug/2016:21:23:01 +0800] "GET /favicon.ico HTTP/1.1" 404 209
::1 - - [24/Aug/2016:21:23:22 +0800] "-" 408 -
::1 - - [24/Aug/2016:21:27:20 +0800] "GET /info.php HTTP/1.1" 200 89908

文章来源: brucelong.blog.csdn.net，作者：Bruce小鬼，版权归原作者所有，如需转载，请联系作者。

原文链接：brucelong.blog.csdn.net/article/details/101598516