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)