Python 自动化办公之“你还在手动操作文件或文件夹吗？”

import os
os.getcwd()
1.
2.

os.path.join("My Project","Demo")
"C:\\" + os.path.join("My Project","Demo")
1.
2.

os.listdir()
os.scandir()
for item in os.scandir():
    print(item.name,item.is_dir(),"\n\t",item.path)
1.
2.
3.
4.

os.listdir("G:\\6Tipdm\\Python集训营_情感分析")
for item in os.scandir("G:\\6Tipdm\\Python集训营_情感分析"):
    print(item.name,item.is_dir(),"\n")
1.
2.
3.

for dirpath, dirnames, files in os.walk("./"):
    print(f"发现文件夹\t{dirpath}")
    print(files)
-----------------------------------------------
 for dirpath, dirnames, files in os.walk("./"):
    print(f"发现文件夹\t{dirpath}")
    print(dirnames) 

"""
dirpath是文件夹路径
dirnames是dirpath这个文件夹下的子文件夹列表
files是dirpath这个文件夹里的文件列表
"""
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.

"abc.txt".startswith("abc")
"abc.txt".endswith(".txt")
------------------------------------------------------
list1 = ["a.txt", "b.py", "c.xlsx", "d.txt", "e.txt"]
for item in list1:
    if  item.endswith(".txt"):
        print(item)
1.
2.
3.
4.
5.
6.
7.

for i in glob.glob("*.txt"):
    print(i)
---------------------------
for i in glob.glob("a*.txt"):
    print(i)
---------------------------
for i in glob.glob("a?.txt"):
    print(i)
---------------------------
for i in glob.glob("a??.txt"):
    print(i)
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.

# 注意：一个*和两个*的区别
glob.glob("*/*.txt",recursive=True)
glob.glob("**/*.txt",recursive=True)
1.
2.
3.

for file in os.scandir():
    print(file.name, file.stat(), "\n")
1.
2.

import time 

for file in os.scandir():
    print(file.name, file.stat().st_size, time.ctime(file.stat().st_ctime), "\n")
1.
2.
3.
4.

os.mkdir("新文件夹名称")：创建单层文件夹；
os.makedirs("第一层/第二层/第三层")：创建多层文件夹；
list1 = ["文件夹{}".format(i) for i in range(5)]
for i in list1:
    os.mkdir(i)
1.
2.
3.
4.
5.

(os.path.exists("新文件夹名称"))。
if not os.path.exists("傻瓜"):
    os.mkdir("傻瓜")
1.
2.
3.

import shutil
# 将aba.txt复制一份到project文件夹中。
shutil.copy("aba.txt", "./project")
# 将aba.txt复制一份到project文件夹中，并重新命名为“新名字.txt”。
shutil.copy("aba.txt", "./project/新名字.txt")
1.
2.
3.
4.
5.

import shutil
shutil.copytree("project", "./qq")
1.
2.

import shutil
# 将aba.txt移动到“傻瓜”文件夹下
shutil.move("aba.txt","./傻瓜/")
# # 将test.txt移动到“傻瓜”文件夹下，并重新命名为test1.txt
shutil.move("test.txt","./傻瓜/test1.txt")
1.
2.
3.
4.
5.

import shutil
# 将“第一层”文件夹移动到“傻瓜”文件夹下
shutil.move("第一层","./傻瓜/")
# 将“qq”文件夹移动到“傻瓜”文件夹下，并重新命名为“哈哈”文件夹
shutil.move("qq","./傻瓜/哈哈")
1.
2.
3.
4.
5.

import os
# 将test1.xlsx重命名为“my.xlsx”
os.rename("test1.xlsx","my.xlsx")
# 将“傻瓜”文件夹重命名为“傻子”文件夹
os.rename("傻瓜","傻子")
1.
2.
3.
4.
5.

import os 
# 删除“my.xlsx”文件
os.remove("my.xlsx")
1.
2.
3.

import shutil
# 删除“文件夹0”这个文件夹
shutil.rmtree("文件夹0")
1.
2.
3.

import zipfile

with zipfile.ZipFile("python办公自动化.zip", "r") as zipobj:
    print(zipobj.namelist())
-----------------------------------------------------------
# 注意：有时候需要写成filename.encode("cp437").decode("gbk")
with zipfile.ZipFile("python办公自动化.zip", "r") as zipobj:
    for filename in zipobj.namelist():
        print(filename.encode("gbk").decode("gbk"))
1.
2.
3.
4.
5.
6.
7.
8.
9.

import zipfile

with zipfile.ZipFile(r"G:\tableau书籍\Tableau文件.zip", "r") as zipobj:
    for filename in zipobj.namelist():
        info = zipobj.getinfo(filename)
        new_filename = filename.encode("cp437").decode("gbk")
        print(new_filename, info.file_size/1024/1024, info.compress_size/1024/1024)
1.
2.
3.
4.
5.
6.
7.

import zipfile
# 将该压缩包中的“a.txt”文件，单独解压到“傻子”文件夹下
with zipfile.ZipFile(r"G:\6Tipdm\7python办公自动化\python办公自动化.zip", "r") as zipobj:
    zipobj.extract("a.txt","./傻子/")
1.
2.
3.
4.

import zipfile
# 将该压缩包整个解压到“文件夹1”文件夹下
with zipfile.ZipFile(r"G:\6Tipdm\7python办公自动化\python办公自动化.zip", "r") as zipobj:
    zipobj.extractall("./文件夹1/")
1.
2.
3.
4.

file_list = ["a.txt", "aa.txt", "文件夹1"]
# 将上述三个文件，进行打包，使用“w”
with zipfile.ZipFile(r"我创建的压缩包.zip", "w") as zipobj:
    for file in file_list:
        zipobj.write(file)
1.
2.
3.
4.
5.

# 往上述压缩包中，再次添加一个新文件“傻子”文件夹，使用“a”
with zipfile.ZipFile(r"我创建的压缩包.zip", "a") as zipobj:
    for file in file_list:
        zipobj.write("傻子")
1.
2.
3.
4.