pandas删除excel列(pandas如何删除列)

1. pandas如何删除列

Python不存在“列”这种数据结来构啊，你说的是list吧？如果是list，那删除起来需要编程，一自个方法是按条件把其他元素拿出来当百一个新list 另外一种方法是用pandas库，把列度表包成series结构，然后series的操作删除很方便

Today was Friday , we

went to the Nanshan park. There were many people there. We went to the zoo. We saw

many kinds of animals there, like kangaroo、pandas、tigers、giraffes and so on.Look here were some

photos about the trip. First we saw the kangaroo and a kangaroo baby in the pouch .Then we saw the pandas were playing with each other.

Next we went to see the tigers .Look there were some little tigers in nursing.After that we went to see the giraffes. Then we ate the lunch. After

lunch we went to buy the gifts. Finally we went back to school by bus. We were

all happy.

那我就举个例子说明一下吧！比如删除以下DataFrame的后两列： 0 1 2 0 1 0 1 1 0 0 1 2 1 0 1 3 0 0 1 4 0 0 1 然后这样写：df.ix[:,~((df==1).all()|(df==0).all())]

df.isna() # 查看缺失值

df.dropna()# 删除所有缺失值

在pandas库中，可以使用dropna()方法直接删除DataFrame对象和Series对象中含有缺失值的数据。

使用函数isnull()和notnull()检查PandasDataFrame中缺少的值。

import pandas as pddata = pd.read_csv('d:/ddd.txt')print(data.drop_duplicates())

只能用索引切片的方式如根据索引对data进行删除重复行，并保留第一个数据： data_unique = data[~data.index.duplicated()]

超过十万行可以正常加载，只是在运算公式的时候会比较卡。一般如此庞大的数据不建议用excel来处理。可以用python pandas包来操作，pandas里面包含了excel的各种函数功能，比如删除重复，填充缺失等而且简单易操作，处理十万行数据不会感觉到明显卡顿。

安装pycharm之后，去下载anaconda，完成之后去配置anaconda全局的环境变量，之后和pycharm关联起来就可以了。anaconda里面包含了一百八十多个科学包和一个python解释器，pandas也包含在anaconda里面，我们直接import pandas就可以调用。

顶一下

(0)

踩一下

(0)