前幾期，有朋友讓我用python將cp的測試數據轉化為map

但是，他又想把特定的測量數據轉化為map圖后，進行上色，即不同的測試數據能夠呈現不同的顏色，以便于直觀的觀察其趨勢。

數據樣式：

左邊列是序號，中間列是XY,X-0016Y0079表示的是（X,Y）坐標為（16，79），最右行是測試數據。序號最大值為13278，即這個wafer有13278粒完成測試，得到了cp的測試數據。

我的思路：

1，將現有數據按照坐標，轉化為map圖，并將測試數值一一對應填入map圖中。

2，有時測試標準是不一樣的，所以可以手動設置標準值，這個在運行程序時能夠彈出對話框，讓使用者能夠隨意更改標準。低于標準值的測量值單元格呈現淺紅色到紅色的漸變，高于標準值的測量值呈現淺綠到紫色的漸變。

做出的效果：

1，雙擊“map上色.exe”運行程序

2，選擇要上色的測試數據文件

3，手動設置標準值

4，設置文件名

5，在原文件地址下輸出包含map圖的文件

6，打開文件

這樣就很直觀地看出測量值的分布圖來了。

原代碼如下，歡迎參考：

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from openpyxl import Workbook
from openpyxl.utils.dataframe import dataframe_to_rows
from openpyxl.styles import PatternFill
from tkinter.simpledialog import askfloat
from tkinter import Tk
from tkinter import filedialog
import colorsys
from tkinter.simpledialog import askstring
def get_threshold(threshold_type):
    print(f"Getting threshold for {threshold_type}...")
    root = Tk()
    root.withdraw()

    if threshold_type == "IL":
        threshold = askfloat(f"Input {threshold_type} Threshold", f"Enter the {threshold_type} threshold:")
        return threshold
    elif threshold_type == "FC":
        threshold_range_str = askstring(f"Input {threshold_type} Threshold Range",
                                        f"Enter the {threshold_type} threshold range (e.g., 'min,max'):")
        print(f"User input for FC threshold: {threshold_range_str}")
        try:
            min_threshold, max_threshold = map(float, threshold_range_str.split(','))
            return min_threshold, max_threshold
        except ValueError:
            print("Invalid input. Please enter two numbers separated by a comma.")
            return None
    root.destroy()
def color_map(value, threshold, data_min, data_max):
    # 正常化值到 [threshold, data_max] 區間，從極淡綠（144,238,144）到紫（128,0,128）
    if threshold <= value <= data_max:
        normed_value = (value - threshold) / (data_max - threshold)
        r = int(144 * (1 - normed_value) + 128 * normed_value)
        g = int(238 * (1 - normed_value) + 0 * normed_value)
        b = int(144 * (1 - normed_value) + 128 * normed_value)

    # 正常化值到 [data_min, threshold] 區間，從紅（255,0,0）到黃（255,255,0）
    elif -10 <= value < threshold:
        normed_value = (value + 10) / (threshold + 10)  # 正則化到 [0, 1] 區間
        r = int(222 + (241 - 222) * normed_value)  # 從 222 漸變到 241
        g = int(28 + (147 - 28) * normed_value)  # 從 28 漸變到 147
        b = int(49 + (156 - 49) * normed_value)  # 從 49 漸變到 156

    elif data_min <= value < -10:
        r, g, b = 139, 0, 0

    else:
        r, g, b = 255, 255, 255  # 默認為白色

    hex_color = 'FF' + '{:02X}{:02X}{:02X}'.format(r, g, b)
    return hex_color


def fc_color_map(value, min_threshold, max_threshold, data_min, data_max):
    if min_threshold <= value <= max_threshold:
       
        normed_value = (value - min_threshold) / (max_threshold - min_threshold)

        hue = normed_value * 360

        r, g, b = colorsys.hsv_to_rgb(hue / 360.0, 1, 1)  # Here saturation and value are both set to 1
        r, g, b = int(r * 255), int(g * 255), int(b * 255)

        hex_color = 'FF' + '{:02X}{:02X}{:02X}'.format(r, g, b)

    # For values outside the specified range
    elif value > max_threshold or value < min_threshold:
        r, g, b = 139, 0, 0
        hex_color = 'FF' + '{:02X}{:02X}{:02X}'.format(r, g, b)
    else:
        r, g, b = 255, 255, 255  # default to white
        hex_color = 'FF' + '{:02X}{:02X}{:02X}'.format(r, g, b)
    return hex_color
def save_to_excel(df, threshold, output_path, color_function):
    wb = Workbook()
    ws = wb.active

    data_min = df.min().min()  # 獲取整個 dataframe 中的最小值
    data_max = df.max().max()  # 獲取整個 dataframe 中的最大值

    for i in range(df.shape[0]):
        for j in range(df.shape[1]):
            value = df.iloc[i, j]
            if not pd.isna(value):
                cell = ws.cell(row=i + 2, column=j + 2)
                cell.value = value
                # 選擇正確的顏色映射函數和參數
                if color_function == color_map:
                    fill_color = color_function(value, threshold, data_min, data_max)
                elif color_function == fc_color_map:
                    min_threshold, max_threshold = threshold  # 從元組中解包
                    fill_color = color_function(value, min_threshold, max_threshold, data_min, data_max)

                cell.fill = PatternFill(start_color=fill_color,
                                        end_color=fill_color,
                                        fill_type="solid")
    wb.save(output_path)

def rgb_to_hex(rgb):
    return '{:02X}{:02X}{:02X}'.format(rgb[0], rgb[1], rgb[2])


def main():
    print("Starting main function...")
    input_file = filedialog.askopenfilename(title="Select the CSV file")
    print(f"Selected file: {input_file}")
    if "il" in input_file.lower():
        threshold_type = "IL"
        color_function = color_map
        threshold = get_threshold(threshold_type)
    else:
        threshold_type = "FC"
        color_function = fc_color_map
        threshold = get_threshold(threshold_type)
????if threshold is None:
        print("Invalid threshold. Exiting program.")
        return

    output_file = filedialog.asksaveasfilename(title="Save the visualization as", defaultextension=".xlsx",
                                               filetypes=[("Excel files", "*.xlsx")])
    print(f"Output file: {output_file}")

    df = pd.read_csv(input_file)
    save_to_excel(df, threshold, output_file, color_function)

if __name__ == "__main__":

main()

審核編輯：劉清