通义灵码 2.0 体验报告：Deepseek 加持下的 Python 开发之旅

import pandas as pd

# 读取 CSV 文件
file_path = 'd://your_file.csv'  # 替换为你的 CSV 文件路径
data = pd.read_csv(file_path)

# 计算每列的平均值
column_means = data.mean()

# 打印每列的平均值
print(column_means)

import unittest
import pandas as pd
from unittest.mock import patch, mock_open

class TestDemoClass(unittest.TestCase):

    @patch('pandas.read_csv')
    def test_calculate_column_means_ValidCSVFile_ReturnsMeans(self, mock_read_csv):
        # 模拟 CSV 文件内容
        mock_data = pd.DataFrame({
            'A': [1, 2, 3],
            'B': [4, 5, 6]
        })
        mock_read_csv.return_value = mock_data

        # 模拟文件路径
        file_path = 'your_file.csv'

        # 调用被测试的代码
        with patch('builtins.open', mock_open(read_data=file_path)):
            # 假设被测试的代码在类的方法中
            demo = DemoClass()
            column_means = demo.calculate_column_means(file_path)

        # 验证结果
        expected_means = pd.Series({'A': 2.0, 'B': 5.0})
        self.assertTrue(column_means.equals(expected_means))

    @patch('pandas.read_csv')
    def test_calculate_column_means_NonNumericData_HandlesGracefully(self, mock_read_csv):
        # 模拟包含非数值数据的 CSV 文件内容
        mock_data = pd.DataFrame({
            'A': ['a', 'b', 'c'],
            'B': [1, 2, 3]
        })
        mock_read_csv.return_value = mock_data

        # 模拟文件路径
        file_path = 'your_file.csv'

        # 调用被测试的代码
        with patch('builtins.open', mock_open(read_data=file_path)):
            demo = DemoClass()
            column_means = demo.calculate_column_means(file_path)

        # 验证结果
        expected_means = pd.Series({'A': 'a', 'B': 2.0})
        self.assertTrue(column_means.equals(expected_means))

    @patch('pandas.read_csv')
    def test_calculate_column_means_FileNotFound_HandlesGracefully(self, mock_read_csv):
        # 模拟文件未找到的情况
        mock_read_csv.side_effect = FileNotFoundError

        # 模拟文件路径
        file_path = 'non_existent_file.csv'

        # 调用被测试的代码
        with patch('builtins.open', mock_open(read_data=file_path)):
            demo = DemoClass()
            with self.assertRaises(FileNotFoundError):
                demo.calculate_column_means(file_path)

错误原因：文件路径错误，无法找到指定的文件。
修复建议：检查文件路径是否正确，确保文件存在。