<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[LongYuTianTang的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/LongYuTianTang</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; LongYuTianTang]]></copyright><item><title><![CDATA[xlwings操作excel插入多行]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/130180220</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/130180220</guid><author>LongYuTianTang</author><pubDate>Sun, 16 Apr 2023 11:09:24 +0800</pubDate><description><![CDATA[xlwings 操作excel插入多行空白]]></description><category></category></item><item><title><![CDATA[Git error: src refspec master does not match any解决办法]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/127799356</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/127799356</guid><author>LongYuTianTang</author><pubDate>Fri, 11 Nov 2022 08:39:08 +0800</pubDate><description><![CDATA[git 报错解决方案]]></description><category></category></item><item><title><![CDATA[vue-element-ui实现表格分页展示]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/111870735</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/111870735</guid><author>LongYuTianTang</author><pubDate>Mon, 28 Dec 2020 17:19:58 +0800</pubDate><description><![CDATA[本次数据采用的是本地数据导入的方式. 也可以通过请求API数据的方式.但是操作之前需要处理跨域.
此次案例使用的数据是https://www.layui.com/demo/table/user/?page=1&amp;limit=1000.
&lt;template&gt;
	&lt;div class="box"&gt;
		  &lt;el-table
		       :data="tableData"
		       style="width: 100%"
			   &gt;
		       ]]></description><category></category></item><item><title><![CDATA[前端手风琴]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/109769154</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/109769154</guid><author>LongYuTianTang</author><pubDate>Wed, 18 Nov 2020 17:01:45 +0800</pubDate><description><![CDATA[js实现
&lt;!DOCTYPE html&gt;
&lt;html lang="en"&gt;
&lt;head&gt;
    &lt;meta charset="UTF-8"&gt;
    &lt;title&gt;手风琴&lt;/title&gt;
    &lt;style&gt;
        *{
            padding: 0;
            margin: 0;
            list-style: none;
            vertica]]></description><category></category></item><item><title><![CDATA[九宫格布局的几种实现方法]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/109714702</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/109714702</guid><author>LongYuTianTang</author><pubDate>Tue, 17 Nov 2020 18:33:48 +0800</pubDate><description><![CDATA[js实现
&lt;!DOCTYPE html&gt;
&lt;html lang="en"&gt;
&lt;head&gt;
    &lt;meta charset="UTF-8"&gt;
    &lt;title&gt;Title&lt;/title&gt;
    &lt;style&gt;
        *{
            padding: 0;
            margin: 0;
            list-style: none;
        }
       ]]></description><category></category></item><item><title><![CDATA[sql语句练习题，答案]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/109443181</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/109443181</guid><author>LongYuTianTang</author><pubDate>Fri, 06 Nov 2020 22:49:35 +0800</pubDate><description><![CDATA[练习网址：http://xuesql.cn/lesson/select_queries_with_expressions
第一节
1【初体验】这是第一题,请你先将左侧的输入框里的内容清空，然后请输入下面的SQL，您将看到所有电影标题：
答案：SELECT * FROM movies;
2【初体验】请输入如下SQL你将看到4条电影（切记先清空数据框且出错要耐心比对）：
答案：SELECT title,director FROM movies WHERE Id &lt; 5
3【初体验】输入如下SQL你将看到电]]></description><category></category></item><item><title><![CDATA[python批量修改对应目录下文件的名称]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/109533475</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/109533475</guid><author>LongYuTianTang</author><pubDate>Fri, 06 Nov 2020 16:32:14 +0800</pubDate><description><![CDATA[最简单的批量修改文件方法.
import os  # 导入os模块
file_list = os.listdir(‘file’) # 读取file文件夹下的文件名称
os.chdir(‘file’) # 切换到该目录下
for i in file_list:
os.rename(i, ‘{}.xlsx’.format(i+“a”)) # 通过循环，修改给每一个文件名称后面添加一个‘a’ （这里后缀写死了，直接用xlsx，如果您的文件不是可以修改为其他的.）

...]]></description><category></category></item><item><title><![CDATA[matplotlib初学笔记]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108394133</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108394133</guid><author>LongYuTianTang</author><pubDate>Thu, 10 Sep 2020 17:19:50 +0800</pubDate><description><![CDATA[https://matplotlib.org/gallery.html

]]></description><category></category></item><item><title><![CDATA[GUI初学-计算器界面]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108326121</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108326121</guid><author>LongYuTianTang</author><pubDate>Mon, 31 Aug 2020 17:42:40 +0800</pubDate><description><![CDATA[import tkinter as tk
root = tk.Tk()
arr = [('MC','M+','M-','MR'),('C','±','/','*'),(7,8,9,'-'),(4,5,6,'+'),(1,2,3,'='),(0,'.')]

tk.Entry(root).grid(row=0,columnspan=4,ipadx=3,sticky=tk.NSEW)
for rindex,r in enumerate(arr):
    for cindex,c in enumerate(r)]]></description><category></category></item><item><title><![CDATA[菜鸟爬虫-scrapy爬取笔趣阁全站小说]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108156891</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108156891</guid><author>LongYuTianTang</author><pubDate>Fri, 21 Aug 2020 21:00:33 +0800</pubDate><description><![CDATA[一 创建爬虫：
cd到我们存放项目的文件夹
然后 scrapy startproject  BQG
cd：BQG
然后 scrapy genspider biquge biduo.cc
二 使用pycharm打开我们的项目目录
1setting设置
这里我是将我的整个文件贴到这里.
# -*- coding: utf-8 -*-
from fake_useragent import UserAgent
# Scrapy settings for BQG project
#
# For simplicity,]]></description><category></category></item><item><title><![CDATA[初学爬虫-有道翻译]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108039372</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108039372</guid><author>LongYuTianTang</author><pubDate>Sun, 16 Aug 2020 17:37:17 +0800</pubDate><description><![CDATA[有道翻译
import requests
import random
import json

url = 'http://fanyi.youdao.com/translate?smartresult=dict&amp;smartresult=rule'
headers = {
    'Host': 'fanyi.youdao.com',
    'Origin': 'http://fanyi.youdao.com',
    'Referer': 'http://fanyi.youdao.com/',
]]></description><category></category></item><item><title><![CDATA[初学爬虫-翻译软件爬虫]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108039286</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108039286</guid><author>LongYuTianTang</author><pubDate>Sun, 16 Aug 2020 17:36:14 +0800</pubDate><description><![CDATA[金山
import requests
import json
url = 'http://fy.iciba.com/ajax.php?a=fy'
word = input('请输入要翻译的信息')
data = {
    'f': 'auto',
    't': 'auto',
    'w': word
}
headers = {
    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, lik]]></description><category></category></item><item><title><![CDATA[python学习线路附带对应资源链接]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108038719</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108038719</guid><author>LongYuTianTang</author><pubDate>Sun, 16 Aug 2020 17:06:52 +0800</pubDate><description><![CDATA[B站python爬虫学些线路

1 Python 基础 BV1Lt4y1U7uN2 Python 进阶 BV1jz411b7DH3 Python 数据库 BV1Pg4y1a7a74 Python GUI与坦克大战 BV1jE411F72o5 Python Numpy BV1jE411F79F6 Python Matplotlib BV1EE411F7od7 Python 并发编程 BV1EE411F7vV8 Python 网络编程 BV1EE411F7Ew9 Python 算法与数据结构 BV1hE411F]]></description><category></category></item><item><title><![CDATA[初学爬虫-糗事百科爬虫]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/107941360</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/107941360</guid><author>LongYuTianTang</author><pubDate>Sun, 16 Aug 2020 10:29:50 +0800</pubDate><description><![CDATA[import requests
from lxml import etree
headers = {
‘User-Agent’: ‘Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36’
}
url = ‘https://www.qidian.com/all’
responese = requests.get(url,headers= head]]></description><category></category></item><item><title><![CDATA[初学爬虫-快代理（2）]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108032801</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108032801</guid><author>LongYuTianTang</author><pubDate>Sun, 16 Aug 2020 10:17:04 +0800</pubDate><description><![CDATA[此次上传只是在之前的代码基础上，修改为面向对象的形式.请各位多指教.
import requests
import time
from lxml import etree
from fake_useragent import UserAgent
import json
# 判断代理是否可用

class get_ip():
  def __init__(self):
    self.headers ={
        'user-agent':UserAgent().random
    }
    s]]></description><category></category></item><item><title><![CDATA[初学爬虫-快代理ip爬取]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108018958</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/108018958</guid><author>LongYuTianTang</author><pubDate>Sat, 15 Aug 2020 10:31:37 +0800</pubDate><description><![CDATA[导包
import requests
import time
from lxml import etree
from fake_useragent import UserAgent
import json

获取每一页的IP内容方法
def get_content(url):
    # url = 'https://www.kuaidaili.com/free/inha/1/'
    headers ={
        'user-agent':UserAgent().random
    }
   ]]></description><category></category></item><item><title><![CDATA[初学爬虫-veer图片下载]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/107993171</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/107993171</guid><author>LongYuTianTang</author><pubDate>Thu, 13 Aug 2020 22:30:09 +0800</pubDate><description><![CDATA[导包
import requests
import pandas as pd
from lxml import etree


目标网站
target='https://www.veer.com/photo/'

请求头
headers = {
            'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari]]></description><category></category></item><item><title><![CDATA[初学爬虫-笔趣阁单本小说爬取（使用selenium）]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/107963394</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/107963394</guid><author>LongYuTianTang</author><pubDate>Wed, 12 Aug 2020 18:08:37 +0800</pubDate><description><![CDATA[# 导包
from selenium import webdriver
import re
dr = webdriver.Chrome()
# 获取每页小说内容的函数
def get_page():
    novel={}
    novel['page_title'] = dr.find_element_by_xpath('//*[@id="BookCon"]/h1').text
    novel['page_content'] = dr.find_element_by_xpath('//*[@id=]]></description><category></category></item><item><title><![CDATA[初学爬虫-qq空间模拟登录]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/107953511</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/107953511</guid><author>LongYuTianTang</author><pubDate>Wed, 12 Aug 2020 11:34:29 +0800</pubDate><description><![CDATA[#导入
from selenium import webdriver
# 模拟打开浏览器
dr = webdriver.Chrome(）
# 隐式延时 等待加载，最长等待30s
dr.implicitly_wait(30)
# 打开目标网站 qq空间网址
dr.get('https://qzone.qq.com/') 
# 跳转登录的框架
fr = dr.find_element_by_id('login_frame')
dr.switch_to.frame(fr)
# 跳转框架之后，点击账号密码登录。
d]]></description><category></category></item><item><title><![CDATA[初学爬虫-腾讯招聘爬虫]]></title><link>https://blog.youkuaiyun.com/LongYuTianTang/article/details/107945646</link><guid>https://blog.youkuaiyun.com/LongYuTianTang/article/details/107945646</guid><author>LongYuTianTang</author><pubDate>Tue, 11 Aug 2020 22:23:18 +0800</pubDate><description><![CDATA[import time
import datetime
import random
import requests
获取一个时间戳
def get_timeStamp():
    times = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
    timeArray = time.strptime(times, "%Y-%m-%d %H:%M:%S")
    timeStamp = str(int(time.mktime(timeArray]]></description><category></category></item></channel></rss>