python 报 KeyError: ('coupon_type', 'occurred at index act_code')故障

本文介绍了一种在使用pandas的apply方法结合lambda函数时遇到的KeyError故障及其解决方案。通过添加axis参数解决了错误,并确保了代码能够正确运行。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

在使用lambda函数时,系统报 KeyError: ('coupon_type', 'occurred at index act_code') 故障

原语句:

data2['type_10001']=data2.apply(lambda x:1 if x['coupon_type']==10001 else 0)

根据故障原因,修改语句为

data2['type_10001']=data2.apply(lambda x:1 if x['coupon_type']==10001 else 0,axis=1)

运行成功

我的意思是只运行一个maxwell程序,就将各个表的数据发送到对应的kafka主题里:# tl;dr config # 日志级别设置为 INFO log_level=info # 数据生产者设置为 Kafka producer=kafka # Kafka 服务器的地址和端口 kafka.bootstrap.servers=hadoop201:9092 # Maxwell 的客户端 ID,用于标识该 Maxwell 实例 client_id=maxwell_online_all_0001 # 生产者根据主键对数据进行分区,有助于数据在 Kafka 主题中的有序存储和消费 producer_partition_by=primary_key # MySQL 登录信息 host=pxc-hzrpmmpz6pgg8e.polarx.rds.aliyuncs.com user=maxwelluser password=vUYzT7FcMwWYJzKyGE2H # JDBC 连接选项,包含不使用 SSL、设置时区为亚洲/上海,允许公钥检索 jdbc_options=useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true # 表映射配置,将不同的表映射到不同的 Kafka 主题 kafka_topic_map=zhelijinxiao_coupon_promotion.shop_info:topic_zhelijinxiao_coupon_promotion__shop_info_one,zhelijinxiao_householdrecycling2.new_order_info:topic_zhelijinxiao_householdrecycling2__new_order_info,zhelijinxiao_order.order_discount:topic_zhelijinxiao_order__order_discount,zhelijinxiao_order.order_info:topic_zhelijinxiao_order__order_info_one,zhelijinxiao_order.order_location:topic_zhelijinxiao_order__order_location,zhelijinxiao_lootactivity.loot_activity:topic_zhelijinxiao_lootactivity__loot_activity,zhelijinxiao_lootactivity.loot_activity_session:topic_zhelijinxiao_lootactivity__loot_activity_session,zhelijinxiao_lootactivity.loot_activity_session_prize:topic_zhelijinxiao_lootactivity__loot_activity_session_prize,zhelijinxiao_makeactivity.make_activity:topic_zhelijinxiao_makeactivity__make_activity,zhelijinxiao_makeactivity.make_activity_session:topic_zhelijinxiao_makeactivity__make_activity_session,zhelijinxiao_makeactivity.make_activity_session_prize:topic_zhelijinxiao_makeactivity__make_activity_session_prize,zhelijinxiao_order.coupon_grant_records:topic_zhelijinxiao_order__coupon_grant_records # 数据筛选规则 filter=exclude:*.*,include:zhelijinxiao_coupon_promotion.shop_info,include:zhelijinxiao_householdrecycling2.new_order_info,include:zhelijinxiao_order.order_discount,include:zhelijinxiao_order.order_info,include:zhelijinxiao_order.order_location,include:zhelijinxiao_loot
最新发布
03-22
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

北.海

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值