python 批量造数据

已于 2023-02-21 10:38:19 修改
阅读量1.3k 收藏 3
点赞数
分类专栏： 测试数据 文章标签： python
于 2022-10-28 11:25:53 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_50813383/article/details/127568319
版权

1. 数据表结构（postgresql）

 Table: public.phm_2040tempo_if_mst
-- DROP TABLE IF EXISTS public.phm_2040tempo_if_mst;
CREATE TABLE IF NOT EXISTS public.phm_2040tempo_if_mst
(
    unei_temban_cd character varying(6) COLLATE pg_catalog."default" NOT NULL,
    shiyo_kaishi_ymd character varying(8) COLLATE pg_catalog."default" NOT NULL,
    shiyo_shuryo_ymd character varying(8) COLLATE pg_catalog."default" NOT NULL,
    toroku_kbn character varying(2) COLLATE pg_catalog."default" NOT NULL,
    kessai_hanei_kbn character varying(5) COLLATE pg_catalog."default",
    tempo_sys_kanren_joho_toroku_jokyo_kbn character varying(2) COLLATE pg_catalog."default",
    hatchu_kanren_joho_toroku_jokyo_kbn character varying(2) COLLATE pg_catalog."default",
    zettai_temban_cd character varying(6) COLLATE pg_catalog."default" NOT NULL,
    temban_cd character varying(6) COLLATE pg_catalog."default",
    tempo_unei_kaishi_ymd character varying(8) COLLATE pg_catalog."default",
    tempo_unei_shuryo_ymd character varying(8) COLLATE pg_catalog."default",
    tempo_meisho_15_moji character varying(90) COLLATE pg_catalog."default",
    tempo_tel_no character varying(15) COLLATE pg_catalog."default",
    kaiten_hm character varying(4) COLLATE pg_catalog."default",
    heiten_hm character varying(4) COLLATE pg_catalog."default",
    tempo_eigyo_time numeric(4,0),
    o24h_eigyo_flg character varying(1) COLLATE pg_catalog."default",
    sake_menkyo_umu_flg character varying(1) COLLATE pg_catalog."default",
    tabako_menkyo_umu_flg character varying(1) COLLATE pg_catalog."default",
    tencho_shain_cd character varying(8) COLLATE pg_catalog."default",
    tencho_shunin_ymd character varying(8) COLLATE pg_catalog."default",
    tencho_yubin_no character varying(8) COLLATE pg_catalog."default",
    tencho_jusho_todofuken_cd character varying(2) COLLATE pg_catalog."default",
    tencho_jusho character varying(240) COLLATE pg_catalog."default",
    tencho_tel_no character varying(15) COLLATE pg_catalog."default",
    fc_tempo_flg character varying(1) COLLATE pg_catalog."default",
    tempo_unei_keitai_kbn character varying(2) COLLATE pg_catalog."default",
    proper_shain_flg character varying(1) COLLATE pg_catalog."default",
    tencho_name_sei character varying(120) COLLATE pg_catalog."default",
    tencho_name_mei character varying(120) COLLATE pg_catalog."default",
    tempo_meisho_zenkaku_kana character varying(90) COLLATE pg_catalog."default",
    tencho_name_zenkaku_kana_sei character varying(240) COLLATE pg_catalog."default",
    tencho_name_zenkaku_kana_mei character varying(240) COLLATE pg_catalog."default",
    tencho_zagaku_kenshu_kaishi_ymd character varying(8) COLLATE pg_catalog."default",
    tencho_tempo_kenshu_kaishi_ymd character varying(8) COLLATE pg_catalog."default",
    tencho_kenko_shindan_ymd character varying(8) COLLATE pg_catalog."default",
    tencho_seinengappi character varying(8) COLLATE pg_catalog."default",
    kikan_gentei_eigyo_time_kaishi_ymd character varying(8) COLLATE pg_catalog."default",
    kikan_gentei_kaiten_hm character varying(4) COLLATE pg_catalog."default",
    kikan_gentei_eigyo_time_shuryo_ymd character varying(8) COLLATE pg_catalog."default",
    kikan_gentei_heiten_hm character varying(4) COLLATE pg_catalog."default",
    kikan_gentei_eigyo_time numeric(2,0),
    kikan_gentei_o24h_eigyo_flg character varying(1) COLLATE pg_catalog."default",
    zenshu_saiyo_teishi_ymd_10_ji character varying(8) COLLATE pg_catalog."default",
    zenshu_saiyo_sai_kaishi_ymd_10_ji character varying(8) COLLATE pg_catalog."default",
    zenshu_saiyo_teishi_ymd_15_ji character varying(8) COLLATE pg_catalog."default",
    zenshu_saiyo_sai_kaishi_ymd_15_ji character varying(8) COLLATE pg_catalog."default",
    hatchu_chiku_cd character varying(2) COLLATE pg_catalog."default",
    sake_menkyo_shutoku_ymd character varying(8) COLLATE pg_catalog."default",
    sake_hambai_kaishi_ymd character varying(8) COLLATE pg_catalog."default",
    sake_hambai_shuryo_ymd character varying(8) COLLATE pg_catalog."default",
    sake_hambai_shubetsu_kbn character varying(2) COLLATE pg_catalog."default",
    sake_fee_ritsu numeric(6,3),
    sake_menkyo_meiginin_hojin_flg character varying(1) COLLATE pg_catalog."default",
    sake_menkyo_meigi_hojin_meisho character varying(120) COLLATE pg_catalog."default",
    sake_menkyo_meigi_kojin_name_sei character varying(120) COLLATE pg_catalog."default",
    sake_menkyo_meigi_kojin_name_mei character varying(120) COLLATE pg_catalog."default",
    sake_hambai_sys_donyu_ymd character varying(8) COLLATE pg_catalog."default",
    kikan_gentei_sake_hambai_kaishi_ymd character varying(8) COLLATE pg_catalog."default",
    kikan_gentei_sake_hambai_shuryo_ymd character varying(8) COLLATE pg_catalog."default",
    sake_minashi_saeki_ritsu numeric(5,2),
    tabako_menkyo_shutoku_ymd character varying(8) COLLATE pg_catalog."default",
    tabako_hambai_kaishi_ymd character varying(8) COLLATE pg_catalog."default",
    tabako_hambai_shuryo_ymd character varying(8) COLLATE pg_catalog."default",
    tabako_koza_kbn character varying(2) COLLATE pg_catalog."default",
    tabako_menkyo_meiginin_hojin_flg character varying(1) COLLATE pg_catalog."default",
    tabako_menkyo_meigi_hojin_meisho character varying(120) COLLATE pg_catalog."default",
    tabako_menkyo_meigi_kojin_name_sei character varying(120) COLLATE pg_catalog."default",
    tabako_menkyo_meigi_kojin_name_mei character varying(120) COLLATE pg_catalog."default",
    tabako_hambai_tempo_cd character varying(20) COLLATE pg_catalog."default",
    tabako_koza_henko_ymd character varying(8) COLLATE pg_catalog."default",
    modem_tel_no character varying(13) COLLATE pg_catalog."default",
    baika_tempo_kata_kbn character varying(2) COLLATE pg_catalog."default",
    setsuzoku_saki_center_kbn character varying(1) COLLATE pg_catalog."default",
    zenken_mst_haishin_ymd character varying(8) COLLATE pg_catalog."default",
    sc_settei_ymd character varying(8) COLLATE pg_catalog."default",
    keitai_henko_ymd character varying(8) COLLATE pg_catalog."default",
    tempo_sys_kaiso_kaishi_ymd character varying(8) COLLATE pg_catalog."default",
    tempo_sys_kaiso_shuryo_ymd character varying(8) COLLATE pg_catalog."default",
    tempo_sys_kaiten_ymd character varying(8) COLLATE pg_catalog."default",
    tempo_sys_heisa_ymd character varying(8) COLLATE pg_catalog."default",
    kaiso_kikan_shuhaishin_kahi_flg character varying(1) COLLATE pg_catalog."default",
    eigyo_ritchi_kbn character varying(2) COLLATE pg_catalog."default",
    keitai_henko_shin_temban_cd character varying(6) COLLATE pg_catalog."default",
    keitai_henko_kyu_temban_cd character varying(6) COLLATE pg_catalog."default",
    shin_tempo_kbn character varying(1) COLLATE pg_catalog."default",
    hombu_temban_kbn character varying(1) COLLATE pg_catalog."default",
    hatchu_model_tempo_kbn character varying(1) COLLATE pg_catalog."default",
    numbers_toriatsukai_umu_flg character varying(1) COLLATE pg_catalog."default",
    fm_fresh_toriatsukai_umu_flg character varying(1) COLLATE pg_catalog."default",
    tempo_manager_name_sei character varying(120) COLLATE pg_catalog."default",
    tempo_manager_name_mei character varying(120) COLLATE pg_catalog."default",
    tempo_manager_name_zenkaku_kana_sei character varying(240) COLLATE pg_catalog."default",
    tempo_manager_name_zenkaku_kana_mei character varying(240) COLLATE pg_catalog."default",
    tempo_manager_seinengappi character varying(8) COLLATE pg_catalog."default",
    gyotai_kbn character varying(2) COLLATE pg_catalog."default",
    pre_open_ymd character varying(8) COLLATE pg_catalog."default",
    receipt_yo_tempo_meisho character varying(96) COLLATE pg_catalog."default",
    receipt_yo_tempo_meisho_kana character varying(96) COLLATE pg_catalog."default",
    receipt_yo_tempo_jusho character varying(192) COLLATE pg_catalog."default",
    bb_kaisen_shubetsu_cd character varying(2) COLLATE pg_catalog."default",
    center_depot_cd character varying(2) COLLATE pg_catalog."default",
    reito_depot_cd character varying(2) COLLATE pg_catalog."default",
    bento_depot_cd character varying(2) COLLATE pg_catalog."default",
    joon_depot_cd character varying(2) COLLATE pg_catalog."default",
    yamapan_depot_cd character varying(2) COLLATE pg_catalog."default",
    nichiyohin_depot_cd character varying(2) COLLATE pg_catalog."default",
    kashi_depot_cd character varying(2) COLLATE pg_catalog."default",
    depot_cd_yobi_1 character varying(2) COLLATE pg_catalog."default",
    depot_cd_yobi_2 character varying(2) COLLATE pg_catalog."default",
    depot_cd_yobi_3 character varying(2) COLLATE pg_catalog."default",
    tokushu_baika_settei_umu_flg character varying(1) COLLATE pg_catalog."default",
    sate_tempo_umu_kbn character varying(1) COLLATE pg_catalog."default",
    sate_tempo_shukei_saki_temban_cd character varying(6) COLLATE pg_catalog."default",
    pos_hi_rendo_credit_toriatsukai_umu_flg character varying(1) COLLATE pg_catalog."default",
    self_pos_register_umu_flg character varying(1) COLLATE pg_catalog."default",
    jido_tsurisen_ki_umu_flg character varying(1) COLLATE pg_catalog."default",
    tempo_sys_renka_han_donyu_tempo_flg character varying(1) COLLATE pg_catalog."default",
    unei_tempo_yobi_kbn_1 character varying(2) COLLATE pg_catalog."default",
    unei_tempo_yobi_kbn_2 character varying(2) COLLATE pg_catalog."default",
    unei_tempo_yobi_kbn_3 character varying(2) COLLATE pg_catalog."default",
    unei_tempo_yobi_kbn_4 character varying(2) COLLATE pg_catalog."default",
    unei_tempo_yobi_kbn_5 character varying(2) COLLATE pg_catalog."default",
    tempo_kaiso_keitai_kbn character varying(1) COLLATE pg_catalog."default",
    todofuken_cd character varying(2) COLLATE pg_catalog."default",
    gyomu_yo_todofuken_kakucho_bu_cd character varying(5) COLLATE pg_catalog."default",
    shikuchoson_cd character varying(5) COLLATE pg_catalog."default",
    eigyosho_no character varying(5) COLLATE pg_catalog."default",
    dist_no character varying(4) COLLATE pg_catalog."default",
    fm_kaisha_cd character varying(4) COLLATE pg_catalog."default",
    zettai_tempo_kaiten_ymd character varying(8) COLLATE pg_catalog."default",
    zettai_tempo_heisa_ymd character varying(8) COLLATE pg_catalog."default",
    yubin_no character varying(8) COLLATE pg_catalog."default",
    tempo_jusho character varying(240) COLLATE pg_catalog."default",
    kinrin_moyori_eki character varying(123) COLLATE pg_catalog."default",
    uriba_menseki numeric(7,2),
    chusha_daisu numeric(7,0),
    ichiji_heisa_ymd character varying(8) COLLATE pg_catalog."default",
    tempo_sai_kaiten_ymd character varying(8) COLLATE pg_catalog."default",
    kaiso_koji_kaishi_ymd character varying(8) COLLATE pg_catalog."default",
    kaiso_koji_shuryo_ymd character varying(8) COLLATE pg_catalog."default",
    ritchi_joken_kbn character varying(2) COLLATE pg_catalog."default",
    tatemono_keitai_kbn character varying(2) COLLATE pg_catalog."default",
    uriba_keitai_kbn character varying(2) COLLATE pg_catalog."default",
    heiten_riyu_kbn character varying(2) COLLATE pg_catalog."default",
    zettai_tempo_yobi_kbn_1 character varying(2) COLLATE pg_catalog."default",
    zettai_tempo_yobi_kbn_2 character varying(2) COLLATE pg_catalog."default",
    zettai_tempo_yobi_kbn_3 character varying(2) COLLATE pg_catalog."default",
    zettai_tempo_yobi_kbn_4 character varying(2) COLLATE pg_catalog."default",
    zettai_tempo_yobi_kbn_5 character varying(2) COLLATE pg_catalog."default",
    menzei_tempo_kbn character varying(2) COLLATE pg_catalog."default",
    menzei_tempo_kbn_meisho character varying(96) COLLATE pg_catalog."default",
    toroku_ymdhms character varying(14) COLLATE pg_catalog."default",
    toroku_sha_id character varying(60) COLLATE pg_catalog."default",
    toroku_shori_id character varying(60) COLLATE pg_catalog."default",
    henko_ymdhms character varying(14) COLLATE pg_catalog."default",
    henko_sha_id character varying(60) COLLATE pg_catalog."default",
    henko_shori_id character varying(60) COLLATE pg_catalog."default",
    sakusei_ymdhmss character varying(17) COLLATE pg_catalog."default" DEFAULT to_char(CURRENT_TIMESTAMP, 'YYYYMMDDHH24MISS00'::text),
    sakusei_shori_id character varying(60) COLLATE pg_catalog."default" DEFAULT 'PH90010-SF010'::character varying,
    sakusei_tanto_sha_id character varying(60) COLLATE pg_catalog."default" DEFAULT 'PH90010-SF010'::character varying,
    koshin_ymdhmss character varying(17) COLLATE pg_catalog."default" DEFAULT to_char(CURRENT_TIMESTAMP, 'YYYYMMDDHH24MISS00'::text),
    koshin_shori_id character varying(60) COLLATE pg_catalog."default" DEFAULT 'PH90010-SF010'::character varying,
    koshin_tanto_sha_id character varying(60) COLLATE pg_catalog."default" DEFAULT 'PH90010-SF010'::character varying,
    data_jotai_kbn character varying(1) COLLATE pg_catalog."default" DEFAULT '1'::character varying,
    CONSTRAINT pk_phm_2040tempo_if_mst PRIMARY KEY (unei_temban_cd, shiyo_kaishi_ymd)
)

  1. 重点： 关联主键是->unei_temban_cd, shiyo_kaishi_ymd 2个字段，并且unei_temban_cd按照接口数据要求是5位数据

  2. 逻辑方式：主要逻辑是按照unei_temban_cd循环100000次，再shiyo_kaishi_ymd用日期去继续循环递增

  3. 注意1：需要按要求去生成的字段需要自己再去加设置条件

  4. 注意2：本次第二个字段是日期字段，按照了日期去循环

完整代码

# 利用python 生成造数据的sql语句，再去数据库中执行

import random
import datetime

# 构造表t_user_weight
import time
import datetime as dt


def create_t_user_weight():
    # 开始执行时间
    start = time.time()
    # 定义需要生成的数据量   算法=count乘以(endtime减去begintime)  例如：10000x(20200201-20200101)=100万
    count = 100000
    # 定义日期主键
    begintime = dt.date(2017, 10, 29)

    # 制表符
    delemiter = "\t"
    # 打开文件，并动态生成sql数据，将数据存在文件中
    try:
        with open("../造数据/insert_t_user_weight.csv", "wb") as fo:
            # 定义数据，以下只是测试数据，可以根据自己的业务通过调用函数去随机生成对应的值
            endtime = dt.date(2017, 11, 2)
            for j in range((endtime - begintime).days + 1):
                day = begintime + dt.timedelta(days=j)
                # print(str(day))
                syear = str(day.year)
                if day.day < 10:
                    sday = '0' + str(day.day)
                else:
                    sday = str(day.day)
                if day.month < 10:
                    smonth = '0' + str(day.month)
                else:
                    smonth = str(day.month)

                sdate = syear + smonth + sday
                print(str(sdate))

                for i in range(1, count):
                    unei_temban_cd = str(i) + delemiter
                    shiyo_kaishi_ymd = str(sdate) + delemiter
                    other_data = "20210217	5	dp	1	2	ahtg	ynvo	19790824	20120417	日本語czwfevluuzyguzwpduysk	13274685007	855	1825	2110	0	0	1	17888832	20010515	944-1116	13	hcmjofsnasrbskltiqsihlskdvnnfdccmblcgppkyxngqj	9143-3-12345681	0	10	1	eujphc	igmrfgobqaoporvnndgqzptwlkj	bnfvkvoixgtedlhksglmobentrzcewblkybkqmsqwnyd	plxztutqgpnlymvfoenjffsatvdrxbruqbbrdlpvkyhgytugwprvtxxfyuxqshxngdgdwa	vpdaztqzjxvyfqfclpyfetljnvlpeqgwnfyisgigsrmjvrambrdbmropxhkroctpyhoh	20120630	20180803	20080629	19780425	19910627	525	19810917	2139	4	0	20011003	19840228	20011227	19830128	13	19890917	20200612	20151227	1	119.66	3	rlrjdudfbgdilcd	wkhw	tzwt	19780608	20020521	19730706	319.66	20040428	19810318	19940704	1	1	mgyfwryetnonnthysbkwn	erkqbkvzasuonhzvst	bpkdiievyfvbemtxcdbbwghmudsto	dbbobfenub	19821027	67101895	2	2	20171107	20100707	19971128	19960423	19871021	20170327	20040318	1	3	ojpu	stxq	0	1	1	1	0	liewemoaqm	hhasfmkibktkxryaukyoimyhtkwwryvr	lyniwphchdyuwsrboxnpjtkkajzaop	nrpobfmqqbejumxgkorjotxxuhmabypsyevihbiurumxmozpytzqpuewtgqjcdjudpfirqibxqlnbva	20120519	3	20090724	pipnyqrkpkrdsufobdfdnruomi	daugfvqlgfnof	rmgkohv	AE	zf	wd	zr	dq	va	fn	zb	yo	tn	ny	0	0	dyuyn	0	0	0	1	zs	ul	vx	px	ou	0	17	93314	90963	16869	8729	8716	19780601	19970103	793-1116	peegittmdpcdmflqhxduevtaexqbolyvkidrkvqxhjmldobuitduiftmiatxk	fimfvbsmwqigdkudksjxyevnlktfelisnitijogl	1956.37	6781972	20021203	20120110	19880820	20180822	5	BI	3	5	er	ju	ey	iw	yq	3	hpvvwqqshqdnpmcpkotpqfdsyslmenxi	20220915155501	test	4	202209155701	4	4"
                    insert_t_user_weight = (
                            '%s' '%s' '%s'
                            % (unei_temban_cd, shiyo_kaishi_ymd, other_data)
                    )
                    # insert_t_user_weight = (
                    #         "INSERT INTO t_user_weight VALUES ('%s', '%s', '%s','%s', '%s', '%s', '%s');"
                    #         % (id, userId, name, sex, weight, address, time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()))
                    # )

                    insert_t_user_weight = insert_t_user_weight + '\n'
                    print(insert_t_user_weight)
                    fo.write(insert_t_user_weight.encode('UTF-8'))
                    data_size = (count-1) * ((endtime - begintime).days+1)
            print(f'共创建{data_size}条sql耗时：{time.time() - start}')
    except Exception as e:
        print(Exception, ":", e)


f __name__ == "__main__":
    create_t_user_weight()

结果数据如图

在这里插入图片描述
在这里插入图片描述

鱼尾酱
关注
  • 0
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
python 实现数据库中数据添加、查询与更新的示例代码
01-19
　最近做web网站的测试，遇到很多需要批量造数据的功能；比如某个页面展示数据条数需要达到10000条进行测试，此时手动构造数据肯定是不可能的，此时只能通过python脚本进行自动构造数据；本次构造数据主要涉及到在...
高性能虚假数据生成器，造数据神器
11-04
"高性能虚假数据生成器，造数据神器"这个标题暗示我们这里涉及的是一个能够高效生成各种类型假数据的工具，可能是一个Python库或软件。在Python社区中，Mimesis（来源于压缩包子文件的文件名称mimesis-master）是一...
[Python造轮子]从零实现一个类关系型数据库
jiede1的博客
03-31 900
前言 进入IT这一行也有几个年头了，该听闻的技术，大都没有遗漏，所以广度上的扩展，不太急迫了，但深度上的扩展，还有很多要做的工作，所以就觉得从 “造轮子” 这方面切入，慢慢扩展自己的深度了。 借助于实现一个数据库，笔者主要的目的有三个： 1.深入了解一个数据库的底层原理，以及要从零实现的话，要包含哪些模块，如何实现 2.这次实现的数据库是玩具级别的，几乎不需要测试我就能知道其具有非常多的缺陷，性...
python faker批量生成数据写入MySQL
k_means123的博客
06-15 126
【代码】python faker批量生成数据写入MySQL。
python批量造数据入库
lzp_88的博客
03-10 288
python 造数据
python连接mysql数据库操作数据批量造数据
sophie1314179的博客
11-17 1143
在项目开发过程中，一般情况会需要很多数据来支持程序的各种操作，本文主要介绍python连接数据库，基本的数据库操作，以及批量插入数据。
Python-快速入门通过接口+random函数，批量造数据
2401_83441752的博客
03-10 433
最近工作中在做性能测试，需要提前造好1万条数据。所以使用python通过接口、字符串+是随机数拼接去造1万条数据。也可以用于接口自动化测试中，数据条数由自己设置
使用Python脚本进行批量造数据
Meng
04-26 6090
目录 1、前言 2、脚本批量造数据 1、前言 针对在数据库里进行批量造数据，之前有发过一篇文章MySQL大批量造数据，是使用存储过程的方法进行批量造数据的。 本篇将采用 Python 脚本的方式进行批量造数据。 2、脚本批量造数据 为了使 Python 可以连上数据库（MySQL），并且可以与数据库交互（增删改查等操作），则需要安装 MySQL 客户端操作库，Python2 中使用 MySQLdb，Python3 中使用 PyMySQL。 作者使用环境为 Python3.8，则安装 P.
python 批量造数据写入Oracle数据库
a874045的博客
03-29 1244
python批量造数
python批量造测试数据存入mysql
yw804909465的博客
04-12 1052
最近测试同事要造100万用户数据，搞了好长时间，头发都揪掉了，我听到后赶紧写个自动生成测试数据来给她解决问题，大家有需要也可以改改使用。 下面的内容都是可以直接copy使用，只需要修改一下mysql连接信息，就可以了。 1. mysql建表 首先我们先用mysql建个test数据库，然后用下面的建表语句建表： -- ---------------------------- -- Table structure for user -- ---------------------------- DR.
【脚本工具】Python在MySQL批量造测试数据
fengyupotest的博客
06-29 1423
批量生成测试数据
python 连接数据库并批量生成数据
weixin_55900951的博客
11-22 701
python mysql连接批量生成数据
如何使用Python语言的Faker库，批量生成可使用的测试数据
11-24
在日常测试中，我们经常需要用到造一些测试数据。如果要是手动制造数据的话，肯定要花费时间精力，这不合理。此时我们应该使用Faker这个Python库，用它来生成各种各样的真数据。
自动生成数据[造数据工具]批量造数据
05-02
批量造数据的主要好处包括： 1. **提高效率**：手动创建大量数据费时且容易出错，自动化工具可以快速生成大量精确的数据，大大节省时间。 2. **灵活性**：这些工具通常允许用户自定义数据类型、范围、分布和模式，...
python3 批量获取对应端口服务的实例
09-18
- **Python 3**：现代编程语言，广泛应用于数据处理、自动化脚本等领域。 - **Python-nmap**：Python的一个库，允许使用Python代码调用nmap进行网络扫描。 - **Multiprocessing**：Python内置库，用于实现多线程或多...
【Python】pandas：排序、重复值、缺省值处理、合并、分组
yannan20190313的博客
07-30 1173
【Python】pandas：排序（sort_index,sort_values,nsmallest,nlargest）、重复值（duplicated,drop_duplicates,value_counts,nunique）、缺省值处理（isna,isnull,notna,notnull,fillna,dropna,replace）、合并（join,merge,append,concat）、分组（groupby）
Python爬虫与MongoDB的完美结合
最新发布
weixin_52392194的博客
08-03 498
我们掌握了在Windows和Linux系统下安装MongoDB，设计适合爬虫存储数据的写入规范，并通过实际爬虫示例展示了如何将爬取到的数据存储到MongoDB中。此外，还进行了MongoDB性能优化，提高了数据存储和查询的效率。
Selenium与WebDriver：Errno 8 Exec格式错误的多种解决方案
ip16yun的博客
07-30 434
在使用Selenium和WebDriver进行网页自动化时，可能会遇到各种错误。其中一个常见问题是执行格式错误（Errno 8 Exec format error）。这个错误通常在运行ChromeDriver时出现，错误提示涉及路径中的某个文件。本文将概述这个问题的背景，并提供多种解决方案，包括如何使用代理IP技术进行数据抓取。
Python批量造数据
06-09
Python可以使用faker库来批量生成假数据，可以生成各种类型的数据，比如姓名、地址、电话号码、电子邮件、公司名称等等。以下是一个使用faker库生成100个用户信息的示例代码： ```python from faker import Faker fake = Faker() for i in range(100): print("User", i+1) print("Name:", fake.name()) print("Address:", fake.address()) print("Phone Number:", fake.phone_number()) print("Email:", fake.email()) print("Company:", fake.company()) print("") ``` 在这个示例代码中，我们首先导入了`Faker`类，然后创建一个`Faker`对象。我们使用`for`循环来生成100个用户信息。对于每个用户，我们使用`fake`对象的相应方法来生成姓名、地址、电话号码、电子邮件和公司名称，最后将这些信息打印出来。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值