我们可以在不使用的情况下同时索引大熊猫的行和列吗?文件上说
使用DataFrame,在[]中切片行。
但是,当我想以相同的方式包含行和列时,它是不工作的。
data = pandas.DataFrame(np.random.rand(10,5), columns = list('abcde'))
data[0:2] #only rows
data.iloc[0:2,0:3] # works.
data[0:2,0:3] # not working in python, but it works similarly in R
我有一个具有下列列和行的数据集
Scored Probabilities for Class "1" Scored Probabilities for Class "2" Scored Probabilities for Class "3" Scored Labels
0.258471 0.009299 0.005433 1
0.154108 0.009577 0.527308
我有一个像这样的熊猫数据帧:
year week city avg_rank
0 2016 52 Paris 1
1 2016 52 Gif-sur-Yvette 2
2 2016 52 Paris 1
3 2017 1 Paris 4
4 2016 52 Paris 3
5 2016 52 Paris
我给一个dataframe分配了一些值,并得到了以下警告消息:
# temp is some data
x = temp[temp.loc[:, cat] == 1]
x.loc[:, "category_id"] = cat # warning occurred here
/home/jupyter-inhyeok_yoo/.conda/envs/test/lib/python3.6/site-packages/pandas/core/indexing.py:1596: SettingWithCopyWarning:
A value is trying to be set
在类似于此的设置中:
>>> import pandas as pd
>>> from random import randint
>>> df = pd.DataFrame({'A': [randint(1, 9) for x in range(10)],
'B': [randint(1, 9)*10 for x in range(10)],
'C': [randint(1, 9)*100 for x in rang
我正在尝试使用pandas在数据帧中搜索数据,然后使用收集的数据将这些数据插入到新数据帧上的特定位置。
假设我的代码是这样的:
If row contains [A] then
x=data.iloc[<row>, <column selection>]
y=data.iloc[<row>, <column selection>]
z=data.iloc[<row>, <column selection>]
insert x to newdataframe at location (y,z