pandas
CNian_
这个作者很懒,什么都没留下…
展开
-
pandas 计算某字段值连续出现的最大次数
def calc_field_value_times(self, data_pd, field, value): """ 计算连续数据 :param data_pd: 要处理的pandas数据集 :param field: 要计算的字段 :param value: 值 :return: """ # 判断值是否存在 if data_pd.query("%s =...原创 2021-11-25 11:08:14 · 3037 阅读 · 0 评论 -
pandas写入excel 不覆盖sheet
import openpyxlimport pandas as pdwb = openpyxl.load_workbook('测试.xlsx')#如果有多个模块可以读写excel文件,这里要指定engine,否则可能会报错writer = pd.ExcelWriter('测试.xlsx',engine='openpyxl')#没有下面这个语句的话excel表将完全被覆盖writer.book = wbdf = pd.DataFrame(data_pd)df.to_excel(writer转载 2021-07-28 16:27:49 · 2430 阅读 · 0 评论 -
python pandas笔记
import pandas as pd data = [ {"id":1, "name": "jack", "age":18, "score": 90}, {"id":2, "name": "ammy", "age":15, "score": 80}, {"id":3, "name": "mark", "age":17, "score": 50}, {"id":4, "name": "appl", "age":21, "score": 67}, {"id":5, "name": .原创 2021-07-05 14:37:54 · 75 阅读 · 0 评论