机器学习Pandas_learn2-CSDN博客

本文链接：https://blog.csdn.net/xiaoadoudou/article/details/146268130

from pandas import DataFrame
paints={"字画名称":{"第一幅":"旭日东升",
                "第二幅":"富水长流",
                "第三幅":"招财进宝",
                "第四幅":"鸿运当头"},
        "字画底价":{"第一幅":2860,"第二幅":498,"第三幅":1068,"第四幅":598},
        "字画拍卖加价":{"第一幅":1000,"第二幅":2000,"第三幅":500,"第四幅":1500}}
goods_in=DataFrame(paints,columns=["字画名称","字画拍卖加价","字画底价"])
print(goods_in)

     字画名称  字画拍卖加价  字画底价
第一幅  旭日东升    1000  2860
第二幅  富水长流    2000   498
第三幅  招财进宝     500  1068
第四幅  鸿运当头    1500   598

from pandas import DataFrame
paints={"字画名称":{"第一幅":"旭日东升",
                "第二幅":"富水长流",
                "第三幅":"招财进宝",
                "第四幅":"鸿运当头"},
        "字画底价":{"第一幅":2860,
                "第二幅":498,
                "第三幅":1068,
                "第四幅":598},
        "字画拍卖加价":{"第一幅":1000,
                       "第二幅":2000,
                       "第三幅":500,
                       "第四幅":1500}}
goods_in=DataFrame(paints)
goods_in_indexes=goods_in.index
goods_in_indexes[1]="字画拍卖底价"
print(goods_in_indexes)

---------------------------------------------------------------------------

TypeError                                 Traceback (most recent call last)

Cell In[2], line 16
     14 goods_in=DataFrame(paints)
     15 goods_in_indexes=goods_in.index
---> 16 goods_in_indexes[1]="字画拍卖底价"
     17 print(goods_in_indexes)


File c:\Program Files\Python313\Lib\site-packages\pandas\core\indexes\base.py:5371, in Index.__setitem__(self, key, value)
   5369 @final
   5370 def __setitem__(self, key, value) -> None:
-> 5371     raise TypeError("Index does not support mutable operations")


TypeError: Index does not support mutable operations

from pandas import DataFrame
paints={"字画名称":["旭日东升","富水长流","招财进宝","鸿运当头"],
        "字画底价":[2860,498,1068,598],
        "字画拍卖加价":[1000,2000,500,1500]}
goods_in=DataFrame(paints,index=[["第一拍卖现场","第一拍卖现场","第二拍卖现场","第二拍卖现场"],
                                 ["第一幅","第二幅","第一幅","第二幅"]])
print(goods_in)

            字画名称  字画底价  字画拍卖加价
第一拍卖现场 第一幅  旭日东升  2860    1000
       第二幅  富水长流   498    2000
第二拍卖现场 第一幅  招财进宝  1068     500
       第二幅  鸿运当头   598    1500

from pandas import DataFrame
paints={"字画名称":["旭日东升","富水长流","招财进宝","鸿运当头"],
        "字画底价":[2860,498,1068,598],
        "字画拍卖加价":[1000,2000,500,1500]}
goods_in=DataFrame(paints,index=[["第一拍卖现场","第一拍卖现场","第二拍卖现场","第二拍卖现场"],
                                 ["第一幅","第二幅","第一幅","第二幅"]])
goods_in_indexes=goods_in.index
print(goods_in_indexes)

MultiIndex([('第一拍卖现场', '第一幅'),
            ('第一拍卖现场', '第二幅'),
            ('第二拍卖现场', '第一幅'),
            ('第二拍卖现场', '第二幅')],
           )

from pandas import DataFrame
paints={"字画名称":["旭日东升","富水长流","招财进宝","鸿运当头"],
        "字画底价":[2860,498,1068,598],
        "字画拍卖加价":[1000,2000,500,1500]}
goods_in=DataFrame(paints,index=[["第一拍卖现场","第一拍卖现场","第二拍卖现场","第二拍卖现场"],
                                 ["第一幅","第二幅","第一幅","第二幅"]])
goods_in_second=goods_in.loc["第二拍卖现场"]
print(goods_in_second)
print("--------------------------------------")
goods_in_second_one=goods_in.loc["第二拍卖现场","第一幅"]
print(goods_in_second_one)

     字画名称  字画底价  字画拍卖加价
第一幅  招财进宝  1068     500
第二幅  鸿运当头   598    1500
--------------------------------------
字画名称      招财进宝
字画底价      1068
字画拍卖加价     500
Name: (第二拍卖现场, 第一幅), dtype: object