利用Pandas进行欧氏测距

2024-04-26 04:58:31 发布

您现在位置:Python中文网/ 问答频道 /正文

我有5列1000+行csv文件。我找到了平均值。但是,我需要你的帮助,以应用欧几里德距离算法和填补缺失的价值。请帮帮我,伙计们。你知道吗

# Importing libraries
import pandas as pd
import numpy as np
from numpy import nan
import csv
from pandas import DataFrame

# Read csv file into a pandas dataframe

df = pd.read_csv(".\SampleData.csv", na_values = missing_values)
print (df)

#Fill the mean value on missing cells

df.fillna(df.mean())

#Fill the Mean value based on Class - Task2
print("Missing fields filled based on Class Value")
df = df.fillna(df.groupby('Class').transform('mean'))
print(df)

我完成了寻找平均值来填补缺失的值


Tags: csvfromimportnumpypandasdfonas