Python 数据清洗--处理Nan

- 日理万妓 2022-01-12 01:37 303阅读 0赞

参考：[http://blog.sina.com.cn/s/blog\_13050351e0102xfis.html][http_blog.sina.com.cn_s_blog_13050351e0102xfis.html]  
[https://www.sogou.com/link?url=DOb0bgH2eKh1ibpaMGjuy-bS\_O7xQYLPIOogrOFmc02ueKW9M67CaVLpMY1k7wxTCB1NmnNSzM-t5pUc3zy0dg][https_www.sogou.com_link_url_DOb0bgH2eKh1ibpaMGjuy-bS_O7xQYLPIOogrOFmc02ueKW9M67CaVLpMY1k7wxTCB1NmnNSzM-t5pUc3zy0dg]..  
[https://www.sogou.com/link?url=DOb0bgH2eKh1ibpaMGjuy6YnbQPc3cuKWH5w\_8iuvJBomuBEhdSpHkUUZED5fr2OXwl-dB-nkEs\_c1NbUyGLxQ][https_www.sogou.com_link_url_DOb0bgH2eKh1ibpaMGjuy6YnbQPc3cuKWH5w_8iuvJBomuBEhdSpHkUUZED5fr2OXwl-dB-nkEs_c1NbUyGLxQ]..  
[https://jingyan.baidu.com/article/ca00d56c1b3647e99eebcfbd.html][https_jingyan.baidu.com_article_ca00d56c1b3647e99eebcfbd.html]

import numpy as np  
import pandas as pd  
from pandas import Series,DataFrame  
from numpy import nan as NaN

import tensorflow as tf  
import matplotlib.pyplot as plt

import scipy.io as sio  
import os

from sklearn import preprocessing

读取mat数据  
load\_path="08\_1.mat"  
load\_data = sio.loadmat(load\_path)  
a = load\_data\['D'\]  
print(a)

data = DataFrame(a)  
print(data)

data.fillna(0)  
print(data.fillna(0))

b=data.fillna(0).values  
print(b)

数据归一化  
a2 = preprocessing.scale(b)  
print('数据归一化：')  
print(a2)

# 数据清洗方法2 删除NAN所在的列 #

load\_path2="08\_1.mat"  
load\_data2 = sio.loadmat(load\_path2)  
a2 = load\_data2\['D'\]

print(a2)

data2 = DataFrame(a2)  
data2.dropna(axis=0, how='any')

print(data2.dropna(axis=0, how='any'))\`

处理前：  
![1436741-20190403162133222-1735435365.png][]

处理后：![1436741-20190403162151394-357672734.png][]

转载于:https://www.cnblogs.com/Ann21/p/10649698.html

[http_blog.sina.com.cn_s_blog_13050351e0102xfis.html]: http://blog.sina.com.cn/s/blog_13050351e0102xfis.html
[https_www.sogou.com_link_url_DOb0bgH2eKh1ibpaMGjuy-bS_O7xQYLPIOogrOFmc02ueKW9M67CaVLpMY1k7wxTCB1NmnNSzM-t5pUc3zy0dg]: https://www.sogou.com/link?url=DOb0bgH2eKh1ibpaMGjuy-bS_O7xQYLPIOogrOFmc02ueKW9M67CaVLpMY1k7wxTCB1NmnNSzM-t5pUc3zy0dg
[https_www.sogou.com_link_url_DOb0bgH2eKh1ibpaMGjuy6YnbQPc3cuKWH5w_8iuvJBomuBEhdSpHkUUZED5fr2OXwl-dB-nkEs_c1NbUyGLxQ]: https://www.sogou.com/link?url=DOb0bgH2eKh1ibpaMGjuy6YnbQPc3cuKWH5w_8iuvJBomuBEhdSpHkUUZED5fr2OXwl-dB-nkEs_c1NbUyGLxQ
[https_jingyan.baidu.com_article_ca00d56c1b3647e99eebcfbd.html]: https://jingyan.baidu.com/article/ca00d56c1b3647e99eebcfbd.html
[1436741-20190403162133222-1735435365.png]: /images/20220109/0a5719c535de4fc5ac545bc0e0b6c822.png
[1436741-20190403162151394-357672734.png]: /images/20220109/16945ea36948472a87e850488fe32fb8.png