Python边学边用，持续更新

1.当输入的数值型数据中包含有非数值型数据时，可以用下面这段代码来进行识别：

def is_float(input_string):
    try:
        float(input_string)
        return True
    except ValueError:
        return False

input_string = input("Enter a number: ")
if is_float(input_string):
    print("Input is a float number.")
else:
    print("Input is not a float number.")

2.利用统计学方法（标准差）来识别一组数据中的异常值，这里用到了Python数据分析中常用的numpy库：

import numpy as np

def find_outliers(data):
    mean = np.mean(data)
    std = np.std(data)
    outliers = []
    for value in data:
        z_score = (value - mean) / std
        if np.abs(z_score) > 3:
            outliers.append(value)
    return outliers

data = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 50, 60, 70, 80, 90, 100]
outliers = find_outliers(data)
print("Outliers:", outliers)

3.创建一个可以浏览本地文件的可视化界面，这里用到了tkinter库和PIL库：

import tkinter as tk
from tkinter import filedialog
from PIL import Image, ImageTk

class ImageViewer:
    def __init__(self, root):
        self.root = root
        self.root.title("Image Viewer")
        self.root.geometry("800x600")

        self.image_files = []
        self.current_index = 0

        self.create_widgets()

    def create_widgets(self):
        toolbar = tk.Frame(self.root)
        toolbar.pack(side="top", fill="x")

        open_button = tk.Button(toolbar, text="Open", command=self.open_folder)
        open_button.pack(side="left")

        prev_button = tk.Button(toolbar, text="Prev", command=self.prev_image)
        prev_button.pack(side="left")

        next_button = tk.Button(toolbar, text="Next", command=self.next_image)
        next_button.pack(side="left")

        self.image_label = tk.Label(self.root)
        self.image_label.pack(fill="both", expand=True)

    def open_folder(self):
        folder = filedialog.askdirectory()
        if folder:
            self.image_files = [f"{folder}/{f}" for f in os.listdir(folder) if f.endswith((".jpg", ".jpeg", ".png"))]
            self.current_index = 0
            self.load_image()

    def prev_image(self):
        if self.image_files:
            self.current_index = (self.current_index - 1) % len(self.image_files)
            self.load_image()

    def next_image(self):
        if self.image_files:
            self.current_index = (self.current_index + 1) % len(self.image_files)
            self.load_image()

    def load_image(self):
        image = Image.open(self.image_files[self.current_index])
        image = image.resize((self.root.winfo_width(), self.root.winfo_height()), Image.ANTIALIAS)
        image = ImageTk.PhotoImage(image)
        self.image_label.config(image=image)
        self.image_label.image = image

root = tk.Tk()
app = ImageViewer(root)
root.mainloop()

4.利用存储在excel文件中的给定的名称列表，创建一系列文件夹，这里用到了os库和pandas库：

import os
import pandas as pd

df = pd.read_excel("folder_names.xlsx", usecols=[0], header=None)
folder_names = df[0].tolist()

root_folder = "C:/Users/Admin/Desktop/newfolder"

for folder_name in folder_names:
    folder_path = os.path.join(root_folder, folder_name)
    if not os.path.exists(folder_path):
        os.makedirs(folder_path)
        print(f"Successfully created {folder_path} folder.")
    else:
        print(f"{folder_path} folder already exists.")

5.对表格进行分割，将C列内容相同的数据单独保存到以C列数据命名的新excel文件中：

import pandas as pd

# 读取excel文件
df = pd.read_excel('file.xlsx')

# 按照C列内容分组
grouped = df.groupby('C')

# 循环每一组
for name, group in grouped:
    # 创建一个新的DataFrame，包含当前组的所有行
    new_df = pd.DataFrame(group)
    # 将新的DataFrame保存到以C列内容命名的excel文件中
    new_df.to_excel(f'C:\\Users\\Admin\\Desktop\\newfolder\\{name}.xlsx', index=False)