自动老李的博客

复刻口播类视频总共分几步

发表于 2026-02-07 本文字数： 44 阅读时长 ≈ 1 分钟

下载视频
提取文案（语音转文本）
文案改写
文本转语音
语音驱动生成数字人视频
添加字幕、封面
上传

使用PyInstaller打包Python程序

发表于 2026-02-04 本文字数： 197 阅读时长 ≈ 1 分钟

打包的意义

方便用户在无需安装Python解释器的情况下使用我们的Python程序。
可以保密我们的源代码

安装PyInstaller

pip install pyinstaller

基本使用

首先，在命令行中进入到要打包的Python脚本所在的目录，然后

pyinstaller your_script.py

即可在同目录得到 dist 文件夹，里面就是打包好的可执行程序。

其他打包选项（常用的）

-F 生成一个独立的单独的可执行文件

-w 运行打包好的程序时，隐藏命令行窗口

-i 为可执行程序设置图标，.ico格式

举例

pyinstaller -F main.py
pyinstaller -F -w -i icon.ico main.py

无人带货直播中用AI回答观众的问题

发表于 2025-01-02 更新于 2025-01-07 本文字数： 267 阅读时长 ≈ 1 分钟

本期分享一个知识点

无人带货直播中如何使用AI来回答观众的问题。

无人直播流程（简化）

收集直播间观众的问题
把问题发给AI，获得回答内容
把回答内容用TTS播放
用数字人朗读回答内容（可选）

与AI交互的两种方式

使用API与AI交互
使用网页与AI交互

使用API与AI交互

收费标准：100万token大概1块钱，可以理解成100万字1块钱，你发给AI的和AI给你回复的都计算字数。

from volcenginesdkarkruntime import Ark  
#pip install --upgrade 'volcengine-python-sdk[ark]'

def answer_question(question):

    try:
        client = Ark(
            api_key = '5dd79c77-c78c-4ab4-a2c4-79d2f6f13fd8',  # 替换成自己的API Key
            base_url="https://ark.cn-beijing.volces.com/api/v3",
        )

        intelligence = 'bot-20241220111057-glnr7'  # 替换成自己的智能体
        completion = client.bot_chat.completions.create(
            model=intelligence,
            messages = [
                {"role": "user", "content": question},
            ],
            timeout=10,
        )

        return completion.choices[0].message.content

    except Exception as e:
        print(e)
        return None


if __name__ == '__main__':
    while True:
        question = input("问题：")
        answer = answer_question(question)
        if answer:
            print(f"回复：{answer}")
        else:
            print("本次回复失败，请重试")

使用网页与AI交互

import time
from DrissionPage import ChromiumPage, ChromiumOptions  
# pip install drissionpage==4.0.5.6


def answer_question_by_web(page:ChromiumPage, question):
    try:
        break_button = page.ele('tag=div@data-testid=chat_input_local_break_button', timeout=1)
        if not break_button:
            print('找不到停止按钮')
            return None
        if break_button.states.is_displayed:
            print('停止按钮是显示状态，说明正在回答问题')
            return None

        input_area = page.ele('tag=textarea@data-testid=chat_input_input', timeout=1)
        if not input_area:
            print('找不到输入框')
            return None
        input_area.input(question, clear=True)
        time.sleep(0.5)

        send_btn = page.ele('tag=button@id=flow-end-msg-send', timeout=1)
        if not send_btn:
            print('找不到发送按钮')
            return None
        send_btn.click()
        time.sleep(1)

        wait_result = page.wait.ele_hidden('tag=div@data-testid=chat_input_local_break_button', timeout=20)
        if not wait_result:
            print('没有等到停止按钮隐藏')
            page.refresh()
            time.sleep(1)
            return None

        message_list = page.ele('tag=div@class:message-list-', timeout=1)
        if not message_list:
            print('找不到消息列表')
            return None
        container = message_list.ele('tag=div@class:inter-', timeout=1)
        if not container:
            print('找不到消息列表2')
            return None

        last_one = container.children()[-1]

        return last_one.text.strip()
    except Exception as e:
        print(e)
        return None


if __name__ == '__main__':
    co = ChromiumOptions()
    co.set_local_port(9222)
    co.use_system_user_path()
    co.set_argument('--start-maximized')
    page = ChromiumPage(co)
    page.get('https://www.doubao.com/chat/646320931514114')

    while True:
        question = input("问题：")
        answer = answer_question_by_web(page, question)
        if answer:
            print(f"回复：{answer}")
        else:
            print("本次回复失败，请重试")

优缺点总结

API方式除了需要付费没别的毛病，快，稳，高并发。

web网页方式优点就是免费，缺点就是代码复杂、容易失效，不能并发，稍慢，有可能触发验证码。

赛博洗牌-两个视频逐帧交叉

发表于 2024-07-21 本文字数： 254 阅读时长 ≈ 1 分钟

功能：

把两个视频逐帧交叉生成一个新视频。把生成的视频上传到B站能实现30帧和60帧下播放不同的内容。具体演示以及原理请看这期视频大会员看热巴，没会员只能看凤姐~特殊剪辑，一个视频包含两个视频流，两个音频流，附原理讲解和制作工具。

下载地址：

https://www.123pan.com/s/QZGSVv-0CyN3.html

v2更新内容：

修复内存占用过大的问题。
取消两个视频必须相同尺寸的限制。
可以设置目标视频的宽和高。
可以设置目标视频的比特率。
可以设置目标视频的声音模式。
日志输出窗口中增加视频导出进度提示。

用Python代码调用GPT-SoVITS

发表于 2024-07-12 本文字数： 117 阅读时长 ≈ 1 分钟

GPT-SoVITS 项目地址：https://github.com/RVC-Boss/GPT-SoVITS

用户手册：https://www.yuque.com/baicaigongchang1145haoyuangong/ib3g1e

import os
import requests
from PySide6.QtCore import QThread
from PySide6.QtWidgets import QWidget, QApplication
from design import Ui_Form
import subprocess
import sounddevice as sd
import soundfile as sf
import psutil


class MyWindow(QWidget, Ui_Form):
    def __init__(self):
        super().__init__()
        self.setupUi(self)
        self.text_te.setFocus()

        self.start_service_btn.clicked.connect(self.start_service_btn_clicked)
        self.close_service_btn.clicked.connect(self.close_service_btn_clicked)
        self.tts_btn.clicked.connect(self.tts_btn_clicked)

    def start_service_btn_clicked(self):
        thread = WorkerThread(self)
        thread.start()

    @staticmethod
    def close_service_btn_clicked():
        port = 9880
        # 查找占用指定端口的进程
        for conn in psutil.net_connections():
            if conn.status == psutil.CONN_LISTEN and conn.laddr.port == port:
                pid = conn.pid
                try:
                    # 使用系统命令结束进程
                    subprocess.run(["taskkill", "/F", "/PID", str(pid)], check=True)
                    print(f"Process with PID {pid} using port {port} terminated.")
                except subprocess.CalledProcessError as e:
                    print(f"Failed to terminate process with PID {pid}: {e}")
                return
        print(f"No process found using port {port}.")

    def tts_btn_clicked(self):
        params = {
            "refer_wav_path": r"D:\BaiduNetdiskDownload\xl\哇，这么多人都在这里玩牌…他们的肚子会不会饿了呀？.wav",
            "prompt_text": "哇，这么多人都在这里玩牌…他们的肚子会不会饿了呀？",
            "prompt_language": "zh",
            "text": self.text_te.toPlainText(),
            "text_language": "zh"
        }

        response = requests.get('http://127.0.0.1:9880/', params=params)

        file_path = 'temp.wav'
        with open(file_path, 'wb') as f:
            f.write(response.content)

        data, samplerate = sf.read(file_path)
        sd.play(data, samplerate)
        sd.wait()


class WorkerThread(QThread):

    def __init__(self, parent=None):
        super().__init__(parent)

    def run(self):
        path = r"D:\BaiduNetdiskDownload\GPT-SoVITS-beta0706fix1\GPT-SoVITS-beta0706"
        # 改变当前工作目录到.bat文件所在目录
        os.chdir(path)
        subprocess.run([r'runtime\python.exe', 'api.py', '-g', r"D:\BaiduNetdiskDownload\xl\xl-e10.ckpt", '-s', r"D:\BaiduNetdiskDownload\xl\xl_e15_s3195.pth"])


if __name__ == "__main__":
    app = QApplication([])
    app.setStyle("Fusion")
    window = MyWindow()
    window.show()
    app.exec()

自动导出剪映草稿

发表于 2024-05-30 本文字数： 270 阅读时长 ≈ 1 分钟

功能：

自动导出剪映草稿

指令代码：

96a79efd133b7043a67956106bb288fb0001000000ffffffff010000000000000006010000008f795b0d0a20207b0d0a20202020226964223a202235303835336539372d336466382d346634642d623031332d313365343138383466666438222c0d0a20202020226e616d65223a2022776f726b666c6f772e666f72222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022666f6c645374617465223a2022556e466f6c64222c0d0a2020202022696e70757473223a207b0d0a202020202020227374617274223a207b0d0a20202020202020202276616c7565223a202231303a31220d0a2020202020207d2c0d0a2020202020202273746f70223a207b0d0a20202020202020202276616c7565223a202231303a31303030220d0a2020202020207d2c0d0a2020202020202273746570223a207b0d0a20202020202020202276616c7565223a202231303a31220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b0d0a202020202020226c6f6f705f696e646578223a207b0d0a2020202020202020226e616d65223a20226c6f6f705f696e646578222c0d0a2020202020202020226973456e61626c65223a20747275650d0a2020202020207d0d0a202020207d0d0a20207d2c0d0a20207b0d0a20202020226964223a202234353861323961632d313864362d343164632d383234632d396235623331323239653833222c0d0a20202020226e616d65223a202270726f6772616d696e672e6c6f67222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b0d0a2020202020202274797065223a207b0d0a20202020202020202276616c7565223a202231303a696e666f222c0d0a202020202020202022646973706c6179223a2022e4bfa1e681af220d0a2020202020207d2c0d0a2020202020202274657874223a207b0d0a20202020202020202276616c7565223a202231353a5b5c2231303ae6ada3e59ca8e5afbce587bae7acac5c222c5c2231313a6c6f6f705f696e6465785c222c5c2231303ae4b8aae88d89e7a8bf5c225d220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202232393632653430612d333534332d346163392d383066662d643432623134306265336637222c0d0a20202020226e616d65223a202277696e33322e77696e646f772e6765745f77696e646f77222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022636f6d6d656e74223a2022e88eb7e58f96e6a087e9a298e4b8ba257469746c6525e79a84e7aa97e58fa3efbc8ce5b086e7aa97e58fa3e5afb9e8b1a1e4bf9de5ad98e588b025726573756c745f77696e646f775f696e7374616e636525222c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f775f74797065223a207b0d0a20202020202020202276616c7565223a202231303a77696e5f7469746c655f6f725f636c617373222c0d0a202020202020202022646973706c6179223a2022e7aa97e58fa3e6a087e9a298e68896e7b1bbe59e8be5908d220d0a2020202020207d2c0d0a2020202020202273656c6563746f72223a207b0d0a20202020202020202276616c7565223a206e756c6c0d0a2020202020207d2c0d0a2020202020202268616e646c65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227469746c65223a207b0d0a20202020202020202276616c7565223a202231303ae589aae698a0e4b893e4b89ae78988220d0a2020202020207d2c0d0a2020202020202268616e646c655f636865636b6564223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a20202020202022636c6173735f6e616d65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227573655f77696c6463617264223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b0d0a20202020202022726573756c745f77696e646f775f696e7374616e6365223a207b0d0a2020202020202020226e616d65223a2022e589aae698a0e7aa97e58fa3222c0d0a2020202020202020226973456e61626c65223a20747275650d0a2020202020207d0d0a202020207d0d0a20207d2c0d0a20207b0d0a20202020226964223a202266316430316234322d376435652d343461322d393663362d366666373638653935363533222c0d0a20202020226e616d65223a202277696e33322e77696e646f772e6163746976617465222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022636f6d6d656e74223a2022e6bf80e6b4bbe7aa97e58fa32577696e646f7725222c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f775f74797065223a207b0d0a20202020202020202276616c7565223a202231303a77696e646f775f696e7374616e6365222c0d0a202020202020202022646973706c6179223a2022e7aa97e58fa3e5afb9e8b1a1220d0a2020202020207d2c0d0a2020202020202277696e646f77223a207b0d0a20202020202020202276616c7565223a202231313ae589aae698a0e7aa97e58fa3222c0d0a202020202020202022646973706c6179223a2022e589aae698a0e7aa97e58fa3220d0a2020202020207d2c0d0a2020202020202273656c6563746f72223a207b0d0a20202020202020202276616c7565223a206e756c6c0d0a2020202020207d2c0d0a2020202020202268616e646c65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227469746c65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a2020202020202268616e646c655f636865636b6564223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a20202020202022636c6173735f6e616d65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227573655f77696c6463617264223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202239303863626635322d306665622d343961342d613030662d306237343234616561666232222c0d0a20202020226e616d65223a202277696e33322e656c656d656e742e636c69636b222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f77223a207b0d0a20202020202020202276616c7565223a202231313ae589aae698a0e7aa97e58fa3222c0d0a202020202020202022646973706c6179223a2022e589aae698a0e7aa97e58fa3220d0a2020202020207d2c0d0a20202020202022656c656d656e74223a207b0d0a20202020202020202276616c7565223a202231323ae7acace4b880e4b8aae88d89e7a8bf222c0d0a202020202020202022646973706c6179223a2022e7acace4b880e4b8aae88d89e7a8bf220d0a2020202020207d2c0d0a20202020202022636c69636b73223a207b0d0a20202020202020202276616c7565223a202231303a636c69636b222c0d0a202020202020202022646973706c6179223a2022e58d95e587bb220d0a2020202020207d2c0d0a20202020202022627574746f6e223a207b0d0a20202020202020202276616c7565223a202231303a6c656674222c0d0a202020202020202022646973706c6179223a2022e9bca0e6a087e5b7a6e994ae220d0a2020202020207d2c0d0a202020202020226b657973223a207b0d0a20202020202020202276616c7565223a202231303a6e756c6c222c0d0a202020202020202022646973706c6179223a2022e697a0220d0a2020202020207d2c0d0a2020202020202264656c61795f6166746572223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a20202020202022616e63686f725f74797065223a207b0d0a20202020202020202276616c7565223a202231303a63656e746572222c0d0a202020202020202022646973706c6179223a2022e4b8ade5bf83e782b9220d0a2020202020207d2c0d0a202020202020227375646f6b755f70617274223a207b0d0a20202020202020202276616c7565223a202231303a4d6964646c6543656e746572220d0a2020202020207d2c0d0a202020202020226f66667365745f78223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226f66667365745f79223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226d6f76655f6d6f757365223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a2020202020202273696d756c617465223a207b0d0a20202020202020202276616c7565223a202231333a54727565220d0a2020202020207d2c0d0a2020202020202274696d656f7574223a207b0d0a20202020202020202276616c7565223a202231303a3230220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202230633538616231332d653532612d343637382d386332322d393436636238316239343262222c0d0a20202020226e616d65223a202277696e33322e77696e646f772e6765745f77696e646f77222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022636f6d6d656e74223a2022e88eb7e58f96e6a087e9a298e4b8ba257469746c6525e79a84e7aa97e58fa3efbc8ce5b086e7aa97e58fa3e5afb9e8b1a1e4bf9de5ad98e588b025726573756c745f77696e646f775f696e7374616e636525222c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f775f74797065223a207b0d0a20202020202020202276616c7565223a202231303a77696e5f7469746c655f6f725f636c617373222c0d0a202020202020202022646973706c6179223a2022e7aa97e58fa3e6a087e9a298e68896e7b1bbe59e8be5908d220d0a2020202020207d2c0d0a2020202020202273656c6563746f72223a207b0d0a20202020202020202276616c7565223a206e756c6c0d0a2020202020207d2c0d0a2020202020202268616e646c65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227469746c65223a207b0d0a20202020202020202276616c7565223a202231303ae589aae698a0e4b893e4b89ae78988220d0a2020202020207d2c0d0a2020202020202268616e646c655f636865636b6564223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a20202020202022636c6173735f6e616d65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227573655f77696c6463617264223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b0d0a20202020202022726573756c745f77696e646f775f696e7374616e6365223a207b0d0a2020202020202020226e616d65223a2022e589aae698a0e7aa97e58fa3222c0d0a2020202020202020226973456e61626c65223a20747275650d0a2020202020207d0d0a202020207d0d0a20207d2c0d0a20207b0d0a20202020226964223a202236643434386636392d396364312d346237382d623438392d663431396236383235383531222c0d0a20202020226e616d65223a202277696e33322e77696e646f772e6163746976617465222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022636f6d6d656e74223a2022e6bf80e6b4bbe7aa97e58fa32577696e646f7725222c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f775f74797065223a207b0d0a20202020202020202276616c7565223a202231303a77696e646f775f696e7374616e6365222c0d0a202020202020202022646973706c6179223a2022e7aa97e58fa3e5afb9e8b1a1220d0a2020202020207d2c0d0a2020202020202277696e646f77223a207b0d0a20202020202020202276616c7565223a202231313ae589aae698a0e7aa97e58fa3222c0d0a202020202020202022646973706c6179223a2022e589aae698a0e7aa97e58fa3220d0a2020202020207d2c0d0a2020202020202273656c6563746f72223a207b0d0a20202020202020202276616c7565223a206e756c6c0d0a2020202020207d2c0d0a2020202020202268616e646c65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227469746c65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a2020202020202268616e646c655f636865636b6564223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a20202020202022636c6173735f6e616d65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227573655f77696c6463617264223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202237323263396632362d396264392d343464652d393862642d653431323865626536306332222c0d0a20202020226e616d65223a202277696e33322e656c656d656e742e636c69636b222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f77223a207b0d0a20202020202020202276616c7565223a202231313ae589aae698a0e7aa97e58fa3222c0d0a202020202020202022646973706c6179223a2022e589aae698a0e7aa97e58fa3220d0a2020202020207d2c0d0a20202020202022656c656d656e74223a207b0d0a20202020202020202276616c7565223a202231323ae5afbce587ba31222c0d0a202020202020202022646973706c6179223a2022e5afbce587ba31220d0a2020202020207d2c0d0a20202020202022636c69636b73223a207b0d0a20202020202020202276616c7565223a202231303a636c69636b222c0d0a202020202020202022646973706c6179223a2022e58d95e587bb220d0a2020202020207d2c0d0a20202020202022627574746f6e223a207b0d0a20202020202020202276616c7565223a202231303a6c656674222c0d0a202020202020202022646973706c6179223a2022e9bca0e6a087e5b7a6e994ae220d0a2020202020207d2c0d0a202020202020226b657973223a207b0d0a20202020202020202276616c7565223a202231303a6e756c6c222c0d0a202020202020202022646973706c6179223a2022e697a0220d0a2020202020207d2c0d0a2020202020202264656c61795f6166746572223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a20202020202022616e63686f725f74797065223a207b0d0a20202020202020202276616c7565223a202231303a63656e746572222c0d0a202020202020202022646973706c6179223a2022e4b8ade5bf83e782b9220d0a2020202020207d2c0d0a202020202020227375646f6b755f70617274223a207b0d0a20202020202020202276616c7565223a202231303a4d6964646c6543656e746572220d0a2020202020207d2c0d0a202020202020226f66667365745f78223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226f66667365745f79223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226d6f76655f6d6f757365223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a2020202020202273696d756c617465223a207b0d0a20202020202020202276616c7565223a202231333a54727565220d0a2020202020207d2c0d0a2020202020202274696d656f7574223a207b0d0a20202020202020202276616c7565223a202231303a3230220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202231303633393963622d643335652d343738382d613130352d393738303264396230646664222c0d0a20202020226e616d65223a202277696e33322e656c656d656e742e636c69636b222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f77223a207b0d0a20202020202020202276616c7565223a202231313ae589aae698a0e7aa97e58fa3222c0d0a202020202020202022646973706c6179223a2022e589aae698a0e7aa97e58fa3220d0a2020202020207d2c0d0a20202020202022656c656d656e74223a207b0d0a20202020202020202276616c7565223a202231323ae5afbce587ba32222c0d0a202020202020202022646973706c6179223a2022e5afbce587ba32220d0a2020202020207d2c0d0a20202020202022636c69636b73223a207b0d0a20202020202020202276616c7565223a202231303a636c69636b222c0d0a202020202020202022646973706c6179223a2022e58d95e587bb220d0a2020202020207d2c0d0a20202020202022627574746f6e223a207b0d0a20202020202020202276616c7565223a202231303a6c656674222c0d0a202020202020202022646973706c6179223a2022e9bca0e6a087e5b7a6e994ae220d0a2020202020207d2c0d0a202020202020226b657973223a207b0d0a20202020202020202276616c7565223a202231303a6e756c6c222c0d0a202020202020202022646973706c6179223a2022e697a0220d0a2020202020207d2c0d0a2020202020202264656c61795f6166746572223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a20202020202022616e63686f725f74797065223a207b0d0a20202020202020202276616c7565223a202231303a63656e746572222c0d0a202020202020202022646973706c6179223a2022e4b8ade5bf83e782b9220d0a2020202020207d2c0d0a202020202020227375646f6b755f70617274223a207b0d0a20202020202020202276616c7565223a202231303a4d6964646c6543656e746572220d0a2020202020207d2c0d0a202020202020226f66667365745f78223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226f66667365745f79223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226d6f76655f6d6f757365223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a2020202020202273696d756c617465223a207b0d0a20202020202020202276616c7565223a202231333a54727565220d0a2020202020207d2c0d0a2020202020202274696d656f7574223a207b0d0a20202020202020202276616c7565223a202231303a3230220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202238653463623662662d633262382d343661342d623234652d353233613331393966313138222c0d0a20202020226e616d65223a202277696e33322e656c656d656e742e77616974222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f77223a207b0d0a20202020202020202276616c7565223a202231313ae589aae698a0e7aa97e58fa3222c0d0a202020202020202022646973706c6179223a2022e589aae698a0e7aa97e58fa3220d0a2020202020207d2c0d0a20202020202022656c656d656e74223a207b0d0a20202020202020202276616c7565223a202231323ae585b3e997ad222c0d0a202020202020202022646973706c6179223a2022e585b3e997ad220d0a2020202020207d2c0d0a202020202020227374617465223a207b0d0a20202020202020202276616c7565223a202231303a617070656172222c0d0a202020202020202022646973706c6179223a2022e7ad89e5be85e58583e7b4a0e587bae78eb0220d0a2020202020207d2c0d0a20202020202022697377616974223a207b0d0a20202020202020202276616c7565223a202231333a54727565220d0a2020202020207d2c0d0a2020202020202274696d656f7574223a207b0d0a20202020202020202276616c7565223a202231303a31383030220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b0d0a20202020202022776169745f726573756c74223a207b0d0a2020202020202020226e616d65223a202277696e5f776169745f726573756c74222c0d0a2020202020202020227661726961626c654c6162656c223a2022e7ad89e5be85e58583e7b4a0e587bae78eb0e7bb93e69e9c222c0d0a2020202020202020226973456e61626c65223a20747275650d0a2020202020207d0d0a202020207d0d0a20207d2c0d0a20207b0d0a20202020226964223a202265653431313164632d623365662d346136622d626430302d303036333033306261646239222c0d0a20202020226e616d65223a202270726f6772616d696e672e736c656570222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b0d0a2020202020202272616e646f6d5f6e756d626572223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a202020202020227365636f6e6473223a207b0d0a20202020202020202276616c7565223a202231303a302e35220d0a2020202020207d2c0d0a2020202020202273746172745f6e756d626572223a207b0d0a20202020202020202276616c7565223a202231303a31220d0a2020202020207d2c0d0a2020202020202273746f705f6e756d626572223a207b0d0a20202020202020202276616c7565223a202231303a35220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202234343435633164362d303864392d343062382d613335322d316630343965613933356363222c0d0a20202020226e616d65223a202277696e33322e656c656d656e742e636c69636b222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f77223a207b0d0a20202020202020202276616c7565223a202231313ae589aae698a0e7aa97e58fa3222c0d0a202020202020202022646973706c6179223a2022e589aae698a0e7aa97e58fa3220d0a2020202020207d2c0d0a20202020202022656c656d656e74223a207b0d0a20202020202020202276616c7565223a202231323ae585b3e997ad222c0d0a202020202020202022646973706c6179223a2022e585b3e997ad220d0a2020202020207d2c0d0a20202020202022636c69636b73223a207b0d0a20202020202020202276616c7565223a202231303a636c69636b222c0d0a202020202020202022646973706c6179223a2022e58d95e587bb220d0a2020202020207d2c0d0a20202020202022627574746f6e223a207b0d0a20202020202020202276616c7565223a202231303a6c656674222c0d0a202020202020202022646973706c6179223a2022e9bca0e6a087e5b7a6e994ae220d0a2020202020207d2c0d0a202020202020226b657973223a207b0d0a20202020202020202276616c7565223a202231303a6e756c6c222c0d0a202020202020202022646973706c6179223a2022e697a0220d0a2020202020207d2c0d0a2020202020202264656c61795f6166746572223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a20202020202022616e63686f725f74797065223a207b0d0a20202020202020202276616c7565223a202231303a63656e746572222c0d0a202020202020202022646973706c6179223a2022e4b8ade5bf83e782b9220d0a2020202020207d2c0d0a202020202020227375646f6b755f70617274223a207b0d0a20202020202020202276616c7565223a202231303a4d6964646c6543656e746572220d0a2020202020207d2c0d0a202020202020226f66667365745f78223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226f66667365745f79223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226d6f76655f6d6f757365223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a2020202020202273696d756c617465223a207b0d0a20202020202020202276616c7565223a202231333a54727565220d0a2020202020207d2c0d0a2020202020202274696d656f7574223a207b0d0a20202020202020202276616c7565223a202231303a3230220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202233303162363661302d666363302d343134632d623631612d623435343861396639646366222c0d0a20202020226e616d65223a202277696e33322e656c656d656e742e636c69636b222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f77223a207b0d0a20202020202020202276616c7565223a202231303a30222c0d0a202020202020202022646973706c6179223a2022e6a0b9e68daee6938de4bd9ce79baee6a087e887aae58aa8e58cb9e9858d220d0a2020202020207d2c0d0a20202020202022656c656d656e74223a207b0d0a20202020202020202276616c7565223a202231323ae98080e587ba222c0d0a202020202020202022646973706c6179223a2022e98080e587ba220d0a2020202020207d2c0d0a20202020202022636c69636b73223a207b0d0a20202020202020202276616c7565223a202231303a636c69636b222c0d0a202020202020202022646973706c6179223a2022e58d95e587bb220d0a2020202020207d2c0d0a20202020202022627574746f6e223a207b0d0a20202020202020202276616c7565223a202231303a6c656674222c0d0a202020202020202022646973706c6179223a2022e9bca0e6a087e5b7a6e994ae220d0a2020202020207d2c0d0a202020202020226b657973223a207b0d0a20202020202020202276616c7565223a202231303a6e756c6c222c0d0a202020202020202022646973706c6179223a2022e697a0220d0a2020202020207d2c0d0a2020202020202264656c61795f6166746572223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a20202020202022616e63686f725f74797065223a207b0d0a20202020202020202276616c7565223a202231303a63656e746572222c0d0a202020202020202022646973706c6179223a2022e4b8ade5bf83e782b9220d0a2020202020207d2c0d0a202020202020227375646f6b755f70617274223a207b0d0a20202020202020202276616c7565223a202231303a4d6964646c6543656e746572220d0a2020202020207d2c0d0a202020202020226f66667365745f78223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226f66667365745f79223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226d6f76655f6d6f757365223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a2020202020202273696d756c617465223a207b0d0a20202020202020202276616c7565223a202231333a54727565220d0a2020202020207d2c0d0a2020202020202274696d656f7574223a207b0d0a20202020202020202276616c7565223a202231303a3230220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202265376637393161622d323235652d343965612d383537382d336162366662623934353139222c0d0a20202020226e616d65223a202277696e33322e77696e646f772e6765745f77696e646f77222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022636f6d6d656e74223a2022e88eb7e58f96e6a087e9a298e4b8ba257469746c6525e79a84e7aa97e58fa3efbc8ce5b086e7aa97e58fa3e5afb9e8b1a1e4bf9de5ad98e588b025726573756c745f77696e646f775f696e7374616e636525222c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f775f74797065223a207b0d0a20202020202020202276616c7565223a202231303a77696e5f7469746c655f6f725f636c617373222c0d0a202020202020202022646973706c6179223a2022e7aa97e58fa3e6a087e9a298e68896e7b1bbe59e8be5908d220d0a2020202020207d2c0d0a2020202020202273656c6563746f72223a207b0d0a20202020202020202276616c7565223a206e756c6c0d0a2020202020207d2c0d0a2020202020202268616e646c65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227469746c65223a207b0d0a20202020202020202276616c7565223a202231303ae589aae698a0e4b893e4b89ae78988220d0a2020202020207d2c0d0a2020202020202268616e646c655f636865636b6564223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a20202020202022636c6173735f6e616d65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227573655f77696c6463617264223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b0d0a20202020202022726573756c745f77696e646f775f696e7374616e6365223a207b0d0a2020202020202020226e616d65223a2022e589aae698a0e7aa97e58fa3222c0d0a2020202020202020226973456e61626c65223a20747275650d0a2020202020207d0d0a202020207d0d0a20207d2c0d0a20207b0d0a20202020226964223a202237376135363663642d366164622d346561362d383362612d383135663863613639343631222c0d0a20202020226e616d65223a202277696e33322e77696e646f772e6163746976617465222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022636f6d6d656e74223a2022e6bf80e6b4bbe7aa97e58fa32577696e646f7725222c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f775f74797065223a207b0d0a20202020202020202276616c7565223a202231303a77696e646f775f696e7374616e6365222c0d0a202020202020202022646973706c6179223a2022e7aa97e58fa3e5afb9e8b1a1220d0a2020202020207d2c0d0a2020202020202277696e646f77223a207b0d0a20202020202020202276616c7565223a202231313ae589aae698a0e7aa97e58fa3222c0d0a202020202020202022646973706c6179223a2022e589aae698a0e7aa97e58fa3220d0a2020202020207d2c0d0a2020202020202273656c6563746f72223a207b0d0a20202020202020202276616c7565223a206e756c6c0d0a2020202020207d2c0d0a2020202020202268616e646c65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227469746c65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a2020202020202268616e646c655f636865636b6564223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a20202020202022636c6173735f6e616d65223a207b0d0a20202020202020202276616c7565223a202231303a220d0a2020202020207d2c0d0a202020202020227573655f77696c6463617264223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202239663637663761322d306132332d346338662d386539652d666262666464353637393665222c0d0a20202020226e616d65223a202277696e33322e656c656d656e742e636c69636b222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f77223a207b0d0a20202020202020202276616c7565223a202231313ae589aae698a0e7aa97e58fa3222c0d0a202020202020202022646973706c6179223a2022e589aae698a0e7aa97e58fa3220d0a2020202020207d2c0d0a20202020202022656c656d656e74223a207b0d0a20202020202020202276616c7565223a202231323ae7acace4b880e4b8aae88d89e7a8bf222c0d0a202020202020202022646973706c6179223a2022e7acace4b880e4b8aae88d89e7a8bf220d0a2020202020207d2c0d0a20202020202022636c69636b73223a207b0d0a20202020202020202276616c7565223a202231303a636c69636b222c0d0a202020202020202022646973706c6179223a2022e58d95e587bb220d0a2020202020207d2c0d0a20202020202022627574746f6e223a207b0d0a20202020202020202276616c7565223a202231303a7269676874222c0d0a202020202020202022646973706c6179223a2022e9bca0e6a087e58fb3e994ae220d0a2020202020207d2c0d0a202020202020226b657973223a207b0d0a20202020202020202276616c7565223a202231303a6e756c6c222c0d0a202020202020202022646973706c6179223a2022e697a0220d0a2020202020207d2c0d0a2020202020202264656c61795f6166746572223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a20202020202022616e63686f725f74797065223a207b0d0a20202020202020202276616c7565223a202231303a63656e746572222c0d0a202020202020202022646973706c6179223a2022e4b8ade5bf83e782b9220d0a2020202020207d2c0d0a202020202020227375646f6b755f70617274223a207b0d0a20202020202020202276616c7565223a202231303a4d6964646c6543656e746572220d0a2020202020207d2c0d0a202020202020226f66667365745f78223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226f66667365745f79223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226d6f76655f6d6f757365223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a2020202020202273696d756c617465223a207b0d0a20202020202020202276616c7565223a202231333a54727565220d0a2020202020207d2c0d0a2020202020202274696d656f7574223a207b0d0a20202020202020202276616c7565223a202231303a3230220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202233383830383330302d343037612d346632632d386235332d626438363864653536323262222c0d0a20202020226e616d65223a202277696e33322e73656e645f6b657973222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b0d0a202020202020226b657973223a207b0d0a20202020202020202276616c7565223a202231303a7b4241434b53504143457d220d0a2020202020207d2c0d0a2020202020202268617264776172655f6472697665725f696e707574223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a20202020202022666f7263655f696d655f656e67223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a20202020202022636f6e7461696e735f686f746b6579223a207b0d0a20202020202020202276616c7565223a202231333a54727565220d0a2020202020207d2c0d0a2020202020202273656e645f6b65795f64656c6179223a207b0d0a20202020202020202276616c7565223a202231303a3530220d0a2020202020207d2c0d0a2020202020202264656c61795f6166746572223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202232353738653530662d643761302d346539662d613335642d613339646362663730616133222c0d0a20202020226e616d65223a202277696e33322e656c656d656e742e636c69636b222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b0d0a2020202020202277696e646f77223a207b0d0a20202020202020202276616c7565223a202231313ae589aae698a0e7aa97e58fa3222c0d0a202020202020202022646973706c6179223a2022e589aae698a0e7aa97e58fa3220d0a2020202020207d2c0d0a20202020202022656c656d656e74223a207b0d0a20202020202020202276616c7565223a202231323ae7a1aee8aea4222c0d0a202020202020202022646973706c6179223a2022e7a1aee8aea4220d0a2020202020207d2c0d0a20202020202022636c69636b73223a207b0d0a20202020202020202276616c7565223a202231303a636c69636b222c0d0a202020202020202022646973706c6179223a2022e58d95e587bb220d0a2020202020207d2c0d0a20202020202022627574746f6e223a207b0d0a20202020202020202276616c7565223a202231303a6c656674222c0d0a202020202020202022646973706c6179223a2022e9bca0e6a087e5b7a6e994ae220d0a2020202020207d2c0d0a202020202020226b657973223a207b0d0a20202020202020202276616c7565223a202231303a6e756c6c222c0d0a202020202020202022646973706c6179223a2022e697a0220d0a2020202020207d2c0d0a2020202020202264656c61795f6166746572223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a20202020202022616e63686f725f74797065223a207b0d0a20202020202020202276616c7565223a202231303a63656e746572222c0d0a202020202020202022646973706c6179223a2022e4b8ade5bf83e782b9220d0a2020202020207d2c0d0a202020202020227375646f6b755f70617274223a207b0d0a20202020202020202276616c7565223a202231303a4d6964646c6543656e746572220d0a2020202020207d2c0d0a202020202020226f66667365745f78223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226f66667365745f79223a207b0d0a20202020202020202276616c7565223a202231303a30220d0a2020202020207d2c0d0a202020202020226d6f76655f6d6f757365223a207b0d0a20202020202020202276616c7565223a202231333a46616c7365220d0a2020202020207d2c0d0a2020202020202273696d756c617465223a207b0d0a20202020202020202276616c7565223a202231333a54727565220d0a2020202020207d2c0d0a2020202020202274696d656f7574223a207b0d0a20202020202020202276616c7565223a202231303a3230220d0a2020202020207d0d0a202020207d2c0d0a20202020226f757470757473223a207b7d0d0a20207d2c0d0a20207b0d0a20202020226964223a202237303164663262622d303337662d343735662d613032342d376639636663393539316464222c0d0a20202020226e616d65223a2022776f726b666c6f772e656e646c6f6f70222c0d0a20202020226973456e61626c6564223a20747275652c0d0a2020202022696e70757473223a207b7d2c0d0a20202020226f757470757473223a207b7d0d0a20207d0d0a5d0b

指令转换工具下载地址：

https://www.123pan.com/s/QZGSVv-3nqN3.html

注意事项：

我的剪映版本5.9.0，其他版本不确定能不能用。（大概率也能用）
除了复制指令，请严格按照教程捕获相应的按钮。
免费脚本不提供任何技术支持服务，本人精力有限，终日为生计奔波，确实没有时间帮各位解决问题，还望多多理解。对于经济宽裕希望付费解决问题的朋友，提供付费技术支持服务，100元每次或100元每30分钟，解决不了问题全额退款，如有需要可加我微信咨询，微信ZiDongLaoLi（自动老李全拼）

使用百度指数数据制作动态图表竞赛

发表于 2024-05-23 本文字数： 725 阅读时长 ≈ 1 分钟

项目介绍

动态图表竞赛（Bar chart race）是一种很早就存在的视频形式。点击查看例子

我要给大家分享的不是项目本身，而是一种获取制作动态图表所需数据的方式。视频形式都是一样的，致胜的关键就是能快捷准确的获取观众感兴趣的数据。

我将给大家分享一个自己写的小工具，使用这个工具可以轻松从百度指数获取制作动态图表所需的数据。

另外，我会演示如何使用数据制作动态图表竞赛视频。

在线制作动态图表竞赛

https://app.flourish.studio/

工具下载地址

https://www.123pan.com/s/QZGSVv-ynyN3.html

工具使用注意事项

电脑安装Chrome浏览器，登录好百度账号。
点击工具的开始按钮之前请关闭Chrome浏览器，或者给浏览器加启动参数 --remote-debugging-port=9222
点击开始按钮之后会自动打开百度指数的页面，请定制自己感兴趣的数据。
数据定制好之后，点击工具的导出按钮，会在脚本同级目录生成数据表格，其格式就是制作动态图表所需的数据格式。

友情提醒

视频形式都一样的前提下，谁的内容更吸引观众谁就能获胜。推荐紧追热点，当前什么热你就做哪方面的数据对比，比如汪峰这两天又上热搜了，那你就可以做一期跟汪峰差不多咖位的歌手近几年热度的对比。再比如小菲菲最近总找事，你就做一期最近10年小菲菲和我们几个城市的GDP对比（用城市对比就可以了，是一个量级的）

总之，什么热做什么，观众想看什么就做什么。

另，使用我的工具，你只需创意，然后简单几步操作就能获得图表数据，大大降低了你获取数据的难度，所以你制作视频的频率就能得到保证，再结合上面的追热点，再加上多平台发布，相信你可以收货不错的流量。流量来了，钱就来了。

获取微博某博主的粉丝列表

发表于 2024-05-20 本文字数： 225 阅读时长 ≈ 1 分钟

功能介绍：

输入微博某博主的主页链接，获取他的粉丝列表信息。

下载地址：

https://www.123pan.com/s/QZGSVv-cXyN3.html

注意事项：

电脑安装Chrome浏览器。
用Chrome浏览器登录微博，然后关闭浏览器。
打开脚本，输入博主主页链接，类似 https://weibo.com/1767819164
任务完成后，在脚本同级目录会生成一个以目标博主ID命名的表格文件，即粉丝列表。

代码

pip install DrissionPage

from DrissionPage import ChromiumPage, ChromiumOptions
from openpyxl import Workbook
from openpyxl.styles import Font, Color


if __name__ == '__main__':

    input_url = input('请输入目标博主主页链接：\n')
    user_id = input_url.split("/")[-1]
    target_url = f'https://weibo.com/u/page/follow/{user_id}?relate=fans'

    # 创建工作簿
    workbook = Workbook()
    # 获取默认的工作表
    sheet = workbook.active
    sheet.append(['昵称', 'ID', '简介', '性别', '粉丝数', '信用分', '创建日期', '城市', '位置', '省份'])
    for cell in sheet[1]:
        cell.font = Font(bold=True, color=Color('FFFF0000'))
    sheet.freeze_panes = 'A2'
    sheet.column_dimensions['A'].width = 20
    sheet.column_dimensions['B'].width = 12
    sheet.column_dimensions['C'].width = 30
    sheet.column_dimensions['D'].width = 7
    sheet.column_dimensions['E'].width = 10
    sheet.column_dimensions['F'].width = 10
    sheet.column_dimensions['G'].width = 20
    sheet.column_dimensions['H'].width = 7
    sheet.column_dimensions['I'].width = 10
    sheet.column_dimensions['J'].width = 7

    co = ChromiumOptions()
    co.use_system_user_path(True)
    page = ChromiumPage(co)

    page.listen.start('https://weibo.com/ajax/friendships/friends')
    page.get(target_url)

    index = 1
    while True:
        page.scroll.down(500)
        res = page.listen.wait(timeout=0.5)
        if res:
            json_data = res.response.body
            users = json_data.get('users', [])
            for user in users:
                name = user.get('name', '')
                uid = user.get('id', 0)
                description = user.get('description', '')
                gender = user.get('gender', '')
                followers_count = user.get('followers_count', 0)
                credit_score = user.get('credit_score', 0)
                created_at = user.get('created_at', '')
                city = user.get('city', '')
                location = user.get('location', '')
                province = user.get('province', '')
                info_list = [name, uid, description, gender, followers_count, credit_score, created_at, city, location, province]
                print(index, info_list)
                index += 1
                sheet.append(info_list)

            next_cursor = json_data.get('next_cursor', 0)
            if next_cursor == 0:
                break

    workbook.save(f'{user_id}.xlsx')

    input('\n任务完成，按回车键退出……')

两个视频逐帧交替播放

发表于 2024-05-18 本文字数： 24 阅读时长 ≈ 1 分钟

功能

把两个视频逐帧交替剪辑，导出为一个新的视频。

from moviepy.audio.AudioClip import CompositeAudioClip
from moviepy.editor import VideoFileClip
from moviepy.video.io.ImageSequenceClip import ImageSequenceClip

# 加载两个视频
video1 = VideoFileClip("video1.mp4")
video2 = VideoFileClip("video2.mp4")

# 获取视频中较短的一方的总帧数
min_frames = int(min(video1.duration * video1.fps, video2.duration * video2.fps))

# 初始化一个空的视频列表
clips = []

# 遍历每一帧，并交替将它们加入到视频列表中
for i in range(min_frames):
    # 交替播放视频1和视频2的帧
    clips.append(video1.get_frame(i / video1.fps))
    clips.append(video2.get_frame(i / video2.fps))

# 将所有帧合并成一个新的视频，为保证原视频速度，帧率设置为原来的2倍
final_clip = ImageSequenceClip(clips, fps=60)

# 按帧取音频进行拼接卡顿感严重，那就直接两个音频并行吧
audio_clip1 = video1.audio.subclip(0, min_frames / video1.fps)
audio_clip2 = video2.audio.subclip(0, min_frames / video2.fps)
combined_audio = CompositeAudioClip([audio_clip1, audio_clip2])

final_clip = final_clip.set_audio(combined_audio)

# 保存新的视频文件
final_clip.write_videofile("result_video.mp4")

视频镜头智能分割

发表于 2024-05-13 本文字数： 363 阅读时长 ≈ 1 分钟

功能说明

把一个视频按照镜头分割成多个视频片段。（核心模型TransNetV2）

下载地址

https://www.123pan.com/s/QZGSVv-1gyN3.html

定制需求

监控A视频平台博主是否发布新视频，检测到新视频自动下载，下载后对视频做自动去重处理，最后上传到B视频平台。（B视频平台为国外平台，有流量就有收益，而且收益颇丰）

监控
下载
去重
上传

去重手段

市面上视频去重软件有很多，但我们要把去重功能集成到自己的脚本中，所以不能使用其他软件，换言之要自己实现去重功能。

去重的手段主要有以下：

抽帧
插帧
裁剪
改分辨率
改画面比例
添加片头片尾
修改帧率
修改比特率
修改亮度、对比度、饱和度
变速
添加视频蒙版
添加图片蒙版
添加贴纸
添加转场
添加背景图片/视频
扫光
修改背景音乐音量
添加额外音轨
镜像反转
画中画
修改元数据
加水印
打乱镜头顺序