Python格式互转之dataframe、字典(dict)、其他对象

Python格式互转之dataframe、字典(dict)、其他对象,第1张

import pandas as pd

data_dict = {
	"key1":1,
	"key2":2,
	"key3":3
}
# dict转dataframe
data_df = pd.Dataframe.from_dict(data_dict, orient="index")..reset_index().rename(columns={"index": "key", 0: "value"})
"""
data_df = 
	key 	value
0	key1	1
1	key2	2
2	key3	3
"""
# dataframe转字典
data_dict = data_df.set_index("key")["value"].to_dict()
"""
data_dict = {
	"key1":1,
	"key2":2,
	"key3":3
}
"""
# 列表对象转dataframe,先将列表转成dict,再通过dict转成dataframe
class Person(object):
    def __init__(self, name='', year=0, salary=0):
        self.name = name
        self.year = year
        self.salary = salary

    def as_dict(self):
        return {'name': self.name, 'year': self.year, 'salary': self.salary}

person1 = Person('john', 2017, 100)
person2 = Person('smith', 2016, 200)
person3 = Person('roger', 2016, 500)

person_list = [person1, person2, person3]

df = pd.DataFrame([x.as_dict() for x in person_list])

print(df)

    name    salary  year
0   john    100     2017
1   smith   200     2016
2   roger   500     2016
## 根据需求更新

欢迎分享,转载请注明来源:内存溢出

原文地址:https://54852.com/langs/733928.html

(0)
打赏 微信扫一扫微信扫一扫 支付宝扫一扫支付宝扫一扫
上一篇 2022-04-27
下一篇2022-04-27

发表评论

登录后才能评论

评论列表(0条)

    保存