对iloc和loc的不同,总是模棱两可,下面通过测试对比一下
import pandas as pd
import os
import numpy as np
设置文件夹
os.chdir("/Users/XXX/Documents/csv“)
打开文件、赋值并添加索引
In [8]:df = pd.read_csv("ex6.csv”)
In [9]: df1 = df.head(10)
In [10]: df1
Out[10]:
one two three four key
0 0.467976 -0.038649 -0.295344 -1.824726 L
1 -0.358893 1.404453 0.704965 -0.200638 B
2 -0.501840 0.659254 -0.421691 -0.057688 G
3 0.204886 1.074134 1.388361 -0.982404 R
4 0.354628 -0.133116 0.283763 -0.837063 Q
5 1.817480 0.742273 0.419395 -2.251035 Q
6 -0.776764 0.935518 -0.332872 -1.875641 U
7 -0.913135 1.530624 -0.572657 0.477252 K
8 0.358480 -0.497572 -0.367016 0.507702 S
9 -1.740877 -1.160417 -1.637830 2.172201 G
In [11]: df1.index = ['A&#