-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathparquet_read_1g.log
More file actions
1029 lines (965 loc) · 153 KB
/
parquet_read_1g.log
File metadata and controls
1029 lines (965 loc) · 153 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
2025-03-31 11:51:45,470 - INFO - 数据前几行示例:
2025-03-31 11:51:45,472 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-12-20T19:30:36+00:00 xsyxsrvt 廖亮 xxpyxvds@hotmail.com 19 622000.0 男 中国 上海市中山人民路178号3单元1510 "{""average_price"":843.5799999999999,""category"":""电子产品"",""items"":[{""id"":36},{""id"":891},{""id"":420},{""id"":587},{""id"":929},{""id"":940},{""id"":519},{""id"":920},{""id"":621}]}" False 2024-08-18 311 896-131-9026
1 2 2023-12-08T15:55:24+00:00 QILDIW 谢芳 pagkjgxr@hotmail.com 40 20000.0 女 俄罗斯 湖南省乌鲁木齐健康路168号1单元459 "{""average_price"":276.31,""category"":""食品"",""items"":[{""id"":824},{""id"":884},{""id"":732},{""id"":305},{""id"":601},{""id"":754},{""id"":27},{""id"":443}]}" False 2022-03-13 449 936-946-5675
2 3 2025-02-03T20:13:49+00:00 NXMSOJN 蔡秀英 nvdjmyij@gmail.com 60 53000.0 女 澳大利亚 广西壮族自治区中山复兴路61号5单元1912 "{""average_price"":213.94,""category"":""家居"",""items"":[{""id"":793},{""id"":241},{""id"":908},{""id"":887}]}" False 2024-12-01 582 857-179-2343
3 4 2024-05-19T18:33:56+00:00 OKVKJOQA 汪明 dblskeyb@outlook.com 74 271000.0 女 澳大利亚 江苏省石家庄广州路182号3单元2003 "{""average_price"":721.81,""category"":""书籍"",""items"":[{""id"":15},{""id"":522},{""id"":893},{""id"":843},{""id"":156},{""id"":150},{""id"":467},{""id"":378},{""id"":891},{""id"":491}]}" False 2023-03-31 678 841-895-7586
4 5 2023-05-02T09:11:31+00:00 TKZDVTZSN 秦秀英 suskeold@hotmail.com 73 66000.0 男 中国 宁夏回族自治区重庆幸福路117号7单元2367 "{""average_price"":627.76,""category"":""食品"",""items"":[{""id"":348},{""id"":565},{""id"":78},{""id"":792},{""id"":980},{""id"":130},{""id"":977},{""id"":53}]}" False 2020-10-12 671 779-124-4986
2025-03-31 11:51:45,472 - INFO - --------------------------------------------------------------------------------
2025-03-31 11:51:46,680 - INFO - 数据前几行示例:
2025-03-31 11:51:46,705 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-12-30T16:21:57+00:00 fomuwjmlw 江思 lhmqhulm@outlook.com 36 886000.0 女 巴西 青海省合肥广州路57号5单元1213 "{""average_price"":619.84,""category"":""食品"",""items"":[{""id"":411},{""id"":283},{""id"":671},{""id"":464},{""id"":529}]}" False 2022-05-04 424 502-470-3541
1 2 2024-06-29T16:24:59+00:00 FUSAJQR 吕杰 zxundoea@outlook.com 30 226000.0 男 印度 河南省长沙东风路154号3单元1179 "{""average_price"":983.17,""category"":""书籍"",""items"":[{""id"":428},{""id"":449},{""id"":225},{""id"":490},{""id"":220},{""id"":732},{""id"":593},{""id"":108}]}" False 2023-07-05 379 575-654-5232
2 3 2024-05-15T21:10:05+00:00 gvzzkmrc 田嘉 khkwgijh@outlook.com 92 807000.0 女 英国 吉林省金华学院路22号7单元2057 "{""average_price"":750.52,""category"":""电子产品"",""items"":[{""id"":692},{""id"":514},{""id"":852},{""id"":144},{""id"":923},{""id"":561},{""id"":434},{""id"":155}]}" False 2023-03-22 795 793-485-5044
3 4 2023-08-22T16:09:22+00:00 UESELUB 叶磊 wqnjvdue@outlook.com 35 145000.0 男 印度 台湾省南昌工业路170号2单元2317 "{""average_price"":923.7700000000001,""category"":""书籍"",""items"":[{""id"":361},{""id"":410},{""id"":327},{""id"":306},{""id"":782},{""id"":395}]}" False 2021-07-02 414 297-758-6341
4 5 2024-01-01T07:48:21+00:00 GQSUBU 马磊 ddajkaog@163.com 25 136000.0 男 德国 山西省徐州人民路36号6单元1374 "{""average_price"":220.87,""category"":""家居"",""items"":[{""id"":332},{""id"":689},{""id"":371},{""id"":175},{""id"":297},{""id"":599},{""id"":680}]}" False 2022-05-08 351 833-918-3483
2025-03-31 11:51:46,705 - INFO - --------------------------------------------------------------------------------
2025-03-31 11:51:48,087 - INFO - 数据前几行示例:
2025-03-31 11:51:48,112 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-03-22T05:14:02+00:00 ladgtp 唐玲 otdekffb@hotmail.com 61 524000.0 其他 澳大利亚 澳门特别行政区温州新华路148号3单元438 "{""average_price"":921.7900000000001,""category"":""服装"",""items"":[{""id"":134},{""id"":741},{""id"":423},{""id"":141},{""id"":928},{""id"":174}]}" False 2022-11-14 589 593-219-7670
1 2 2023-12-10T11:59:48+00:00 ydbpkymj 潘玲 nisgdysd@hotmail.com 45 526000.0 女 巴西 新疆维吾尔自治区昆明中山路43号1单元634 "{""average_price"":576.28,""category"":""电子产品"",""items"":[{""id"":223}]}" False 2022-03-17 481 935-256-9289
2 3 2023-05-22T08:56:07+00:00 akudv 林宏 wireteca@163.com 20 904000.0 女 澳大利亚 陕西省兰州文化路42号4单元550 "{""average_price"":705.9699999999999,""category"":""电子产品"",""items"":[{""id"":209},{""id"":525},{""id"":188},{""id"":339},{""id"":290}]}" False 2020-11-28 315 290-109-3000
3 4 2023-01-12T16:03:41+00:00 QNQFFFSRS 邱霞 alfsyuaw@qq.com 39 330000.0 男 日本 陕西省杭州友谊路14号1单元1609 "{""average_price"":275.32,""category"":""家居"",""items"":[{""id"":628},{""id"":939}]}" False 2020-01-28 440 709-976-5486
4 5 2023-06-30T17:26:53+00:00 JGAKPKYAT 秦波 ujlxnjww@gmail.com 96 430000.0 男 中国 甘肃省烟台胜利路69号7单元155 "{""average_price"":893.08,""category"":""服装"",""items"":[{""id"":954},{""id"":23},{""id"":493},{""id"":873}]}" False 2021-02-28 820 268-404-3607
2025-03-31 11:51:48,112 - INFO - --------------------------------------------------------------------------------
2025-03-31 11:51:49,531 - INFO - 数据前几行示例:
2025-03-31 11:51:49,556 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-15T02:06:51+00:00 DFPYPK 冯娜 xlbvwqnk@126.com 77 36000.0 女 巴西 青海省绍兴青年路90号1单元241 "{""average_price"":361.45,""category"":""食品"",""items"":[{""id"":466},{""id"":448},{""id"":6},{""id"":59},{""id"":302},{""id"":845},{""id"":386},{""id"":846},{""id"":337},{""id"":617}]}" False 2024-10-16 693 924-519-5030
1 2 2023-01-05T14:43:16+00:00 wzobou 马晓 pqkfyphb@gmail.com 96 714000.0 男 德国 江西省保定北京路123号3单元1336 "{""average_price"":406.99,""category"":""家居"",""items"":[{""id"":542},{""id"":952},{""id"":759},{""id"":615},{""id"":968},{""id"":650},{""id"":459}]}" False 2020-01-11 823 371-860-4475
2 3 2024-11-17T23:59:54+00:00 ftotzea 傅佳 deihadwa@outlook.com 30 841000.0 男 日本 四川省温州平安路152号5单元2424 "{""average_price"":152.56,""category"":""服装"",""items"":[{""id"":233},{""id"":595},{""id"":704},{""id"":279},{""id"":690},{""id"":42},{""id"":752},{""id"":153},{""id"":285},{""id"":716}]}" False 2024-06-01 381 655-419-5633
3 4 2023-10-01T16:58:51+00:00 wwsbbu 马雨 diwflftg@gmail.com 53 950000.0 女 俄罗斯 江西省南通长江路97号7单元659 "{""average_price"":712.9,""category"":""电子产品"",""items"":[{""id"":131},{""id"":281},{""id"":207},{""id"":22}]}" False 2021-10-05 532 644-588-9573
4 5 2024-02-23T13:10:07+00:00 wtbca 杨玲 bxuurmyu@163.com 88 522000.0 男 日本 江苏省南昌人民路150号2单元784 "{""average_price"":489.15999999999997,""category"":""家居"",""items"":[{""id"":37}]}" False 2022-09-10 769 971-685-5134
2025-03-31 11:51:49,556 - INFO - --------------------------------------------------------------------------------
2025-03-31 11:51:51,059 - INFO - 数据前几行示例:
2025-03-31 11:51:51,084 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-07-18T20:47:01+00:00 hcvomsn 阎欣怡 gdbepeeo@qq.com 96 957000.0 女 俄罗斯 广西壮族自治区郑州西湖路30号2单元255 "{""average_price"":73.36,""category"":""服装"",""items"":[{""id"":310},{""id"":149},{""id"":218}]}" False 2021-04-12 822 320-378-2335
1 2 2023-06-27T08:01:35+00:00 qzzqwskj 汪雨 krxwzgui@163.com 83 948000.0 男 美国 台湾省石家庄广州路38号5单元486 "{""average_price"":412.92999999999995,""category"":""服装"",""items"":[{""id"":401},{""id"":191},{""id"":669},{""id"":161},{""id"":116},{""id"":556}]}" False 2021-02-20 736 357-247-8081
2 3 2023-05-14T07:03:05+00:00 MOMJKHJ 蔡娜 zislhnwf@hotmail.com 58 34000.0 男 印度 江西省昆明上海路172号3单元571 "{""average_price"":879.22,""category"":""食品"",""items"":[{""id"":196},{""id"":660},{""id"":587},{""id"":917},{""id"":369}]}" False 2020-11-09 569 271-702-2445
3 4 2023-11-23T05:24:11+00:00 gdpwmam 彭涵 ngjrhsvl@163.com 36 793000.0 女 英国 新疆维吾尔自治区无锡安宁路87号7单元446 "{""average_price"":327.79,""category"":""书籍"",""items"":[{""id"":893},{""id"":807},{""id"":786}]}" False 2022-02-05 424 466-458-4564
4 5 2023-05-11T13:35:04+00:00 jhuwwefsr 江玲 xhqwgvhq@hotmail.com 54 525000.0 女 法国 内蒙古自治区嘉兴西湖路167号2单元599 "{""average_price"":565.3900000000001,""category"":""家居"",""items"":[{""id"":963},{""id"":375},{""id"":308}]}" False 2020-11-02 542 276-694-6283
2025-03-31 11:51:51,084 - INFO - --------------------------------------------------------------------------------
2025-03-31 11:51:52,679 - INFO - 数据前几行示例:
2025-03-31 11:51:52,702 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-09T01:38:20+00:00 UZPFPZJ 彭敏 xtnlkqsb@qq.com 36 73000.0 女 俄罗斯 广西壮族自治区绍兴和谐路152号2单元1384 "{""average_price"":15.940000000000001,""category"":""家居"",""items"":[{""id"":631},{""id"":762},{""id"":233},{""id"":535},{""id"":118},{""id"":449},{""id"":256},{""id"":404},{""id"":99},{""id"":638}]}" False 2024-10-02 423 918-668-7857
1 2 2023-07-08T22:53:52+00:00 UEHSG 高杰 rkpktrqz@outlook.com 58 223000.0 女 巴西 黑龙江省大连建设路127号1单元1835 "{""average_price"":563.4100000000001,""category"":""食品"",""items"":[{""id"":425},{""id"":678},{""id"":72},{""id"":666}]}" False 2021-03-19 567 205-503-3300
2 3 2023-12-31T20:00:57+00:00 fxuujvnk 姜子轩 vwnquvla@outlook.com 88 858000.0 男 美国 浙江省厦门繁荣路15号5单元1442 "{""average_price"":669.34,""category"":""书籍"",""items"":[{""id"":395},{""id"":148},{""id"":731},{""id"":847}]}" False 2022-05-07 767 673-105-7503
3 4 2023-03-22T11:12:02+00:00 DDERCI 梁云 jpajekzz@qq.com 61 485000.0 男 德国 四川省宁波上海路30号6单元2134 "{""average_price"":637.66,""category"":""书籍"",""items"":[{""id"":908},{""id"":793},{""id"":121},{""id"":530},{""id"":826},{""id"":395},{""id"":869},{""id"":510},{""id"":506},{""id"":159}]}" False 2020-07-08 587 387-482-7104
4 5 2024-08-10T11:43:08+00:00 RTABMQKQLG 钱俊 haqlhpmb@163.com 33 437000.0 男 中国 四川省成都康乐路181号6单元391 "{""average_price"":505.0,""category"":""家居"",""items"":[{""id"":307},{""id"":439},{""id"":590},{""id"":16},{""id"":393},{""id"":738},{""id"":65},{""id"":519},{""id"":363}]}" False 2023-10-12 404 602-478-3001
2025-03-31 11:51:52,703 - INFO - --------------------------------------------------------------------------------
2025-03-31 11:51:54,505 - INFO - 数据前几行示例:
2025-03-31 11:51:54,530 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-25T07:15:59+00:00 gtlcuz 于宏 ykxyfhgm@163.com 96 746000.0 男 日本 福建省乌鲁木齐东风路80号6单元2277 "{""average_price"":736.66,""category"":""服装"",""items"":[{""id"":295},{""id"":397},{""id"":798},{""id"":906},{""id"":916},{""id"":953},{""id"":855},{""id"":201},{""id"":140},{""id"":302}]}" False 2024-11-09 819 936-365-4573
1 2 2024-10-10T23:32:13+00:00 nbcpsl 马鹏 vfiteszh@hotmail.com 29 944000.0 男 日本 西藏自治区重庆新华路61号6单元662 "{""average_price"":226.81,""category"":""书籍"",""items"":[{""id"":265},{""id"":459},{""id"":817},{""id"":843},{""id"":128}]}" False 2024-03-04 373 924-957-8702
2 3 2025-02-13T22:44:56+00:00 gsbhu 徐雨 yduzrewc@163.com 36 123000.0 女 澳大利亚 江西省长沙青年路163号6单元407 "{""average_price"":596.0799999999999,""category"":""书籍"",""items"":[{""id"":304},{""id"":181},{""id"":895},{""id"":706},{""id"":832},{""id"":972},{""id"":685},{""id"":305}]}" False 2024-12-25 419 371-760-3106
3 4 2023-04-24T03:46:06+00:00 YAAYX 林强 zutmavfa@163.com 58 132000.0 男 美国 安徽省中山振兴路61号2单元2249 "{""average_price"":494.11,""category"":""书籍"",""items"":[{""id"":732},{""id"":126},{""id"":813},{""id"":783},{""id"":36},{""id"":995},{""id"":15},{""id"":661},{""id"":65},{""id"":191}]}" False 2020-09-22 569 463-338-5133
4 5 2023-07-10T07:48:22+00:00 TAJJHCND 廖强 pvyzvahj@outlook.com 57 278000.0 女 巴西 澳门特别行政区南昌西湖路118号7单元377 "{""average_price"":676.2700000000001,""category"":""电子产品"",""items"":[{""id"":327},{""id"":596},{""id"":59},{""id"":997},{""id"":685},{""id"":804},{""id"":185},{""id"":735},{""id"":126},{""id"":489}]}" False 2021-03-23 564 214-297-9938
2025-03-31 11:51:54,530 - INFO - --------------------------------------------------------------------------------
2025-03-31 11:51:56,341 - INFO - 数据前几行示例:
2025-03-31 11:51:56,375 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-09-11T21:05:26+00:00 xwrnixyn 田亮 tefwjoji@hotmail.com 95 625000.0 男 美国 山西省太原学院路37号7单元594 "{""average_price"":306.01,""category"":""食品"",""items"":[{""id"":579},{""id"":186},{""id"":892},{""id"":206},{""id"":503},{""id"":847},{""id"":830},{""id"":347}]}" False 2023-12-27 813 786-620-2670
1 2 2024-12-26T08:26:10+00:00 cztdqb 董欣 kpfuiggp@126.com 24 932000.0 男 美国 广西壮族自治区东莞东风路115号4单元999 "{""average_price"":667.36,""category"":""书籍"",""items"":[{""id"":341}]}" False 2024-08-31 344 552-862-8469
2 3 2024-11-20T00:24:35+00:00 bebtqxuw 潘红 hxusqnzs@outlook.com 78 538000.0 女 英国 云南省中山兴隆路102号3单元210 "{""average_price"":809.9200000000001,""category"":""书籍"",""items"":[{""id"":46},{""id"":598},{""id"":957},{""id"":209},{""id"":335}]}" False 2024-06-06 701 616-533-4370
3 4 2023-09-01T11:43:33+00:00 QZCNRKTUV 孔敏 sstvzrnr@126.com 93 81000.0 男 日本 吉林省宁波兴华路169号3单元2079 "{""average_price"":600.04,""category"":""家居"",""items"":[{""id"":61},{""id"":232},{""id"":925}]}" False 2021-07-26 799 697-896-8597
4 5 2023-11-01T12:00:35+00:00 TSHFYITMO 白军 gwgxobwc@hotmail.com 79 159000.0 女 德国 吉林省乌鲁木齐学院路152号5单元1100 "{""average_price"":517.87,""category"":""家居"",""items"":[{""id"":274},{""id"":975},{""id"":904},{""id"":729},{""id"":781},{""id"":882},{""id"":708},{""id"":864},{""id"":632},{""id"":686}]}" False 2021-12-16 706 141-638-9617
2025-03-31 11:51:56,375 - INFO - --------------------------------------------------------------------------------
2025-03-31 11:51:56,408 - INFO - None
2025-03-31 11:51:57,498 - INFO - id age income credit_score
count 10000000.00 10000000.00 10000000.00 10000000.00
mean 49000.50 59.01 499400.43 575.09
std 28850.19 23.95 289011.11 159.01
min 1.00 18.00 0.00 300.00
25% 24039.00 38.00 249000.00 437.00
50% 48077.00 59.00 499000.00 575.00
75% 73959.00 80.00 750000.00 713.00
max 100000.00 100.00 1000000.00 850.00
2025-03-31 11:52:01,454 - INFO - 数据中不存在缺失值
2025-03-31 11:52:01,494 - INFO - 数据中不存在年龄非法值
2025-03-31 11:52:21,450 - WARNING - 数据中性别列存在异常值，异常值数量: 0
2025-03-31 11:52:21,450 - WARNING - 数据中存在重复行，重复行重复量: 8800000
2025-03-31 11:53:08,436 - INFO - 删除重复行后，数据框中已无重复行。
2025-03-31 11:53:20,205 - INFO - 开始执行 cluster_and_analyze 函数
2025-03-31 11:53:20,205 - INFO - 开始提取 purchase_history 中的 average_price 和 items 的长度
2025-03-31 11:53:26,997 - INFO - 提取完成
2025-03-31 11:53:27,001 - INFO - 选择的特征为: ['income', 'average_price', 'items_count']
2025-03-31 11:53:27,002 - INFO - 开始进行数据标准化
2025-03-31 11:53:27,033 - INFO - 数据标准化完成
2025-03-31 11:53:27,034 - INFO - 开始确定最优聚类数
2025-03-31 11:53:27,034 - INFO - 开始尝试聚类数 k = 2
2025-03-31 11:53:27,034 - INFO - 创建 KMeans 模型，聚类数设置为 2，随机种子设置为 42
2025-03-31 11:53:27,034 - INFO - 开始使用标准化后的特征数据对 KMeans 模型（k=2）进行训练
2025-03-31 11:53:27,536 - INFO - 获取 KMeans 模型（k=2）训练后每个样本的聚类标签
2025-03-31 11:53:27,536 - INFO - 开始计算 KMeans 模型（k=2）聚类结果的轮廓系数
2025-03-31 12:00:11,391 - INFO - 数据前几行示例:
2025-03-31 12:00:11,392 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-12-20T19:30:36+00:00 xsyxsrvt 廖亮 xxpyxvds@hotmail.com 19 622000.0 男 中国 上海市中山人民路178号3单元1510 "{""average_price"":843.5799999999999,""category"":""电子产品"",""items"":[{""id"":36},{""id"":891},{""id"":420},{""id"":587},{""id"":929},{""id"":940},{""id"":519},{""id"":920},{""id"":621}]}" False 2024-08-18 311 896-131-9026
1 2 2023-12-08T15:55:24+00:00 QILDIW 谢芳 pagkjgxr@hotmail.com 40 20000.0 女 俄罗斯 湖南省乌鲁木齐健康路168号1单元459 "{""average_price"":276.31,""category"":""食品"",""items"":[{""id"":824},{""id"":884},{""id"":732},{""id"":305},{""id"":601},{""id"":754},{""id"":27},{""id"":443}]}" False 2022-03-13 449 936-946-5675
2 3 2025-02-03T20:13:49+00:00 NXMSOJN 蔡秀英 nvdjmyij@gmail.com 60 53000.0 女 澳大利亚 广西壮族自治区中山复兴路61号5单元1912 "{""average_price"":213.94,""category"":""家居"",""items"":[{""id"":793},{""id"":241},{""id"":908},{""id"":887}]}" False 2024-12-01 582 857-179-2343
3 4 2024-05-19T18:33:56+00:00 OKVKJOQA 汪明 dblskeyb@outlook.com 74 271000.0 女 澳大利亚 江苏省石家庄广州路182号3单元2003 "{""average_price"":721.81,""category"":""书籍"",""items"":[{""id"":15},{""id"":522},{""id"":893},{""id"":843},{""id"":156},{""id"":150},{""id"":467},{""id"":378},{""id"":891},{""id"":491}]}" False 2023-03-31 678 841-895-7586
4 5 2023-05-02T09:11:31+00:00 TKZDVTZSN 秦秀英 suskeold@hotmail.com 73 66000.0 男 中国 宁夏回族自治区重庆幸福路117号7单元2367 "{""average_price"":627.76,""category"":""食品"",""items"":[{""id"":348},{""id"":565},{""id"":78},{""id"":792},{""id"":980},{""id"":130},{""id"":977},{""id"":53}]}" False 2020-10-12 671 779-124-4986
2025-03-31 12:00:11,392 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:00:12,582 - INFO - 数据前几行示例:
2025-03-31 12:00:12,607 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-12-30T16:21:57+00:00 fomuwjmlw 江思 lhmqhulm@outlook.com 36 886000.0 女 巴西 青海省合肥广州路57号5单元1213 "{""average_price"":619.84,""category"":""食品"",""items"":[{""id"":411},{""id"":283},{""id"":671},{""id"":464},{""id"":529}]}" False 2022-05-04 424 502-470-3541
1 2 2024-06-29T16:24:59+00:00 FUSAJQR 吕杰 zxundoea@outlook.com 30 226000.0 男 印度 河南省长沙东风路154号3单元1179 "{""average_price"":983.17,""category"":""书籍"",""items"":[{""id"":428},{""id"":449},{""id"":225},{""id"":490},{""id"":220},{""id"":732},{""id"":593},{""id"":108}]}" False 2023-07-05 379 575-654-5232
2 3 2024-05-15T21:10:05+00:00 gvzzkmrc 田嘉 khkwgijh@outlook.com 92 807000.0 女 英国 吉林省金华学院路22号7单元2057 "{""average_price"":750.52,""category"":""电子产品"",""items"":[{""id"":692},{""id"":514},{""id"":852},{""id"":144},{""id"":923},{""id"":561},{""id"":434},{""id"":155}]}" False 2023-03-22 795 793-485-5044
3 4 2023-08-22T16:09:22+00:00 UESELUB 叶磊 wqnjvdue@outlook.com 35 145000.0 男 印度 台湾省南昌工业路170号2单元2317 "{""average_price"":923.7700000000001,""category"":""书籍"",""items"":[{""id"":361},{""id"":410},{""id"":327},{""id"":306},{""id"":782},{""id"":395}]}" False 2021-07-02 414 297-758-6341
4 5 2024-01-01T07:48:21+00:00 GQSUBU 马磊 ddajkaog@163.com 25 136000.0 男 德国 山西省徐州人民路36号6单元1374 "{""average_price"":220.87,""category"":""家居"",""items"":[{""id"":332},{""id"":689},{""id"":371},{""id"":175},{""id"":297},{""id"":599},{""id"":680}]}" False 2022-05-08 351 833-918-3483
2025-03-31 12:00:12,607 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:00:13,891 - INFO - 数据前几行示例:
2025-03-31 12:00:13,917 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-03-22T05:14:02+00:00 ladgtp 唐玲 otdekffb@hotmail.com 61 524000.0 其他 澳大利亚 澳门特别行政区温州新华路148号3单元438 "{""average_price"":921.7900000000001,""category"":""服装"",""items"":[{""id"":134},{""id"":741},{""id"":423},{""id"":141},{""id"":928},{""id"":174}]}" False 2022-11-14 589 593-219-7670
1 2 2023-12-10T11:59:48+00:00 ydbpkymj 潘玲 nisgdysd@hotmail.com 45 526000.0 女 巴西 新疆维吾尔自治区昆明中山路43号1单元634 "{""average_price"":576.28,""category"":""电子产品"",""items"":[{""id"":223}]}" False 2022-03-17 481 935-256-9289
2 3 2023-05-22T08:56:07+00:00 akudv 林宏 wireteca@163.com 20 904000.0 女 澳大利亚 陕西省兰州文化路42号4单元550 "{""average_price"":705.9699999999999,""category"":""电子产品"",""items"":[{""id"":209},{""id"":525},{""id"":188},{""id"":339},{""id"":290}]}" False 2020-11-28 315 290-109-3000
3 4 2023-01-12T16:03:41+00:00 QNQFFFSRS 邱霞 alfsyuaw@qq.com 39 330000.0 男 日本 陕西省杭州友谊路14号1单元1609 "{""average_price"":275.32,""category"":""家居"",""items"":[{""id"":628},{""id"":939}]}" False 2020-01-28 440 709-976-5486
4 5 2023-06-30T17:26:53+00:00 JGAKPKYAT 秦波 ujlxnjww@gmail.com 96 430000.0 男 中国 甘肃省烟台胜利路69号7单元155 "{""average_price"":893.08,""category"":""服装"",""items"":[{""id"":954},{""id"":23},{""id"":493},{""id"":873}]}" False 2021-02-28 820 268-404-3607
2025-03-31 12:00:13,917 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:00:15,267 - INFO - 数据前几行示例:
2025-03-31 12:00:15,293 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-15T02:06:51+00:00 DFPYPK 冯娜 xlbvwqnk@126.com 77 36000.0 女 巴西 青海省绍兴青年路90号1单元241 "{""average_price"":361.45,""category"":""食品"",""items"":[{""id"":466},{""id"":448},{""id"":6},{""id"":59},{""id"":302},{""id"":845},{""id"":386},{""id"":846},{""id"":337},{""id"":617}]}" False 2024-10-16 693 924-519-5030
1 2 2023-01-05T14:43:16+00:00 wzobou 马晓 pqkfyphb@gmail.com 96 714000.0 男 德国 江西省保定北京路123号3单元1336 "{""average_price"":406.99,""category"":""家居"",""items"":[{""id"":542},{""id"":952},{""id"":759},{""id"":615},{""id"":968},{""id"":650},{""id"":459}]}" False 2020-01-11 823 371-860-4475
2 3 2024-11-17T23:59:54+00:00 ftotzea 傅佳 deihadwa@outlook.com 30 841000.0 男 日本 四川省温州平安路152号5单元2424 "{""average_price"":152.56,""category"":""服装"",""items"":[{""id"":233},{""id"":595},{""id"":704},{""id"":279},{""id"":690},{""id"":42},{""id"":752},{""id"":153},{""id"":285},{""id"":716}]}" False 2024-06-01 381 655-419-5633
3 4 2023-10-01T16:58:51+00:00 wwsbbu 马雨 diwflftg@gmail.com 53 950000.0 女 俄罗斯 江西省南通长江路97号7单元659 "{""average_price"":712.9,""category"":""电子产品"",""items"":[{""id"":131},{""id"":281},{""id"":207},{""id"":22}]}" False 2021-10-05 532 644-588-9573
4 5 2024-02-23T13:10:07+00:00 wtbca 杨玲 bxuurmyu@163.com 88 522000.0 男 日本 江苏省南昌人民路150号2单元784 "{""average_price"":489.15999999999997,""category"":""家居"",""items"":[{""id"":37}]}" False 2022-09-10 769 971-685-5134
2025-03-31 12:00:15,293 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:00:16,774 - INFO - 数据前几行示例:
2025-03-31 12:00:16,800 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-07-18T20:47:01+00:00 hcvomsn 阎欣怡 gdbepeeo@qq.com 96 957000.0 女 俄罗斯 广西壮族自治区郑州西湖路30号2单元255 "{""average_price"":73.36,""category"":""服装"",""items"":[{""id"":310},{""id"":149},{""id"":218}]}" False 2021-04-12 822 320-378-2335
1 2 2023-06-27T08:01:35+00:00 qzzqwskj 汪雨 krxwzgui@163.com 83 948000.0 男 美国 台湾省石家庄广州路38号5单元486 "{""average_price"":412.92999999999995,""category"":""服装"",""items"":[{""id"":401},{""id"":191},{""id"":669},{""id"":161},{""id"":116},{""id"":556}]}" False 2021-02-20 736 357-247-8081
2 3 2023-05-14T07:03:05+00:00 MOMJKHJ 蔡娜 zislhnwf@hotmail.com 58 34000.0 男 印度 江西省昆明上海路172号3单元571 "{""average_price"":879.22,""category"":""食品"",""items"":[{""id"":196},{""id"":660},{""id"":587},{""id"":917},{""id"":369}]}" False 2020-11-09 569 271-702-2445
3 4 2023-11-23T05:24:11+00:00 gdpwmam 彭涵 ngjrhsvl@163.com 36 793000.0 女 英国 新疆维吾尔自治区无锡安宁路87号7单元446 "{""average_price"":327.79,""category"":""书籍"",""items"":[{""id"":893},{""id"":807},{""id"":786}]}" False 2022-02-05 424 466-458-4564
4 5 2023-05-11T13:35:04+00:00 jhuwwefsr 江玲 xhqwgvhq@hotmail.com 54 525000.0 女 法国 内蒙古自治区嘉兴西湖路167号2单元599 "{""average_price"":565.3900000000001,""category"":""家居"",""items"":[{""id"":963},{""id"":375},{""id"":308}]}" False 2020-11-02 542 276-694-6283
2025-03-31 12:00:16,800 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:00:18,258 - INFO - 数据前几行示例:
2025-03-31 12:00:18,284 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-09T01:38:20+00:00 UZPFPZJ 彭敏 xtnlkqsb@qq.com 36 73000.0 女 俄罗斯 广西壮族自治区绍兴和谐路152号2单元1384 "{""average_price"":15.940000000000001,""category"":""家居"",""items"":[{""id"":631},{""id"":762},{""id"":233},{""id"":535},{""id"":118},{""id"":449},{""id"":256},{""id"":404},{""id"":99},{""id"":638}]}" False 2024-10-02 423 918-668-7857
1 2 2023-07-08T22:53:52+00:00 UEHSG 高杰 rkpktrqz@outlook.com 58 223000.0 女 巴西 黑龙江省大连建设路127号1单元1835 "{""average_price"":563.4100000000001,""category"":""食品"",""items"":[{""id"":425},{""id"":678},{""id"":72},{""id"":666}]}" False 2021-03-19 567 205-503-3300
2 3 2023-12-31T20:00:57+00:00 fxuujvnk 姜子轩 vwnquvla@outlook.com 88 858000.0 男 美国 浙江省厦门繁荣路15号5单元1442 "{""average_price"":669.34,""category"":""书籍"",""items"":[{""id"":395},{""id"":148},{""id"":731},{""id"":847}]}" False 2022-05-07 767 673-105-7503
3 4 2023-03-22T11:12:02+00:00 DDERCI 梁云 jpajekzz@qq.com 61 485000.0 男 德国 四川省宁波上海路30号6单元2134 "{""average_price"":637.66,""category"":""书籍"",""items"":[{""id"":908},{""id"":793},{""id"":121},{""id"":530},{""id"":826},{""id"":395},{""id"":869},{""id"":510},{""id"":506},{""id"":159}]}" False 2020-07-08 587 387-482-7104
4 5 2024-08-10T11:43:08+00:00 RTABMQKQLG 钱俊 haqlhpmb@163.com 33 437000.0 男 中国 四川省成都康乐路181号6单元391 "{""average_price"":505.0,""category"":""家居"",""items"":[{""id"":307},{""id"":439},{""id"":590},{""id"":16},{""id"":393},{""id"":738},{""id"":65},{""id"":519},{""id"":363}]}" False 2023-10-12 404 602-478-3001
2025-03-31 12:00:18,284 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:00:19,950 - INFO - 数据前几行示例:
2025-03-31 12:00:19,976 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-25T07:15:59+00:00 gtlcuz 于宏 ykxyfhgm@163.com 96 746000.0 男 日本 福建省乌鲁木齐东风路80号6单元2277 "{""average_price"":736.66,""category"":""服装"",""items"":[{""id"":295},{""id"":397},{""id"":798},{""id"":906},{""id"":916},{""id"":953},{""id"":855},{""id"":201},{""id"":140},{""id"":302}]}" False 2024-11-09 819 936-365-4573
1 2 2024-10-10T23:32:13+00:00 nbcpsl 马鹏 vfiteszh@hotmail.com 29 944000.0 男 日本 西藏自治区重庆新华路61号6单元662 "{""average_price"":226.81,""category"":""书籍"",""items"":[{""id"":265},{""id"":459},{""id"":817},{""id"":843},{""id"":128}]}" False 2024-03-04 373 924-957-8702
2 3 2025-02-13T22:44:56+00:00 gsbhu 徐雨 yduzrewc@163.com 36 123000.0 女 澳大利亚 江西省长沙青年路163号6单元407 "{""average_price"":596.0799999999999,""category"":""书籍"",""items"":[{""id"":304},{""id"":181},{""id"":895},{""id"":706},{""id"":832},{""id"":972},{""id"":685},{""id"":305}]}" False 2024-12-25 419 371-760-3106
3 4 2023-04-24T03:46:06+00:00 YAAYX 林强 zutmavfa@163.com 58 132000.0 男 美国 安徽省中山振兴路61号2单元2249 "{""average_price"":494.11,""category"":""书籍"",""items"":[{""id"":732},{""id"":126},{""id"":813},{""id"":783},{""id"":36},{""id"":995},{""id"":15},{""id"":661},{""id"":65},{""id"":191}]}" False 2020-09-22 569 463-338-5133
4 5 2023-07-10T07:48:22+00:00 TAJJHCND 廖强 pvyzvahj@outlook.com 57 278000.0 女 巴西 澳门特别行政区南昌西湖路118号7单元377 "{""average_price"":676.2700000000001,""category"":""电子产品"",""items"":[{""id"":327},{""id"":596},{""id"":59},{""id"":997},{""id"":685},{""id"":804},{""id"":185},{""id"":735},{""id"":126},{""id"":489}]}" False 2021-03-23 564 214-297-9938
2025-03-31 12:00:19,976 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:00:21,624 - INFO - 数据前几行示例:
2025-03-31 12:00:21,650 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-09-11T21:05:26+00:00 xwrnixyn 田亮 tefwjoji@hotmail.com 95 625000.0 男 美国 山西省太原学院路37号7单元594 "{""average_price"":306.01,""category"":""食品"",""items"":[{""id"":579},{""id"":186},{""id"":892},{""id"":206},{""id"":503},{""id"":847},{""id"":830},{""id"":347}]}" False 2023-12-27 813 786-620-2670
1 2 2024-12-26T08:26:10+00:00 cztdqb 董欣 kpfuiggp@126.com 24 932000.0 男 美国 广西壮族自治区东莞东风路115号4单元999 "{""average_price"":667.36,""category"":""书籍"",""items"":[{""id"":341}]}" False 2024-08-31 344 552-862-8469
2 3 2024-11-20T00:24:35+00:00 bebtqxuw 潘红 hxusqnzs@outlook.com 78 538000.0 女 英国 云南省中山兴隆路102号3单元210 "{""average_price"":809.9200000000001,""category"":""书籍"",""items"":[{""id"":46},{""id"":598},{""id"":957},{""id"":209},{""id"":335}]}" False 2024-06-06 701 616-533-4370
3 4 2023-09-01T11:43:33+00:00 QZCNRKTUV 孔敏 sstvzrnr@126.com 93 81000.0 男 日本 吉林省宁波兴华路169号3单元2079 "{""average_price"":600.04,""category"":""家居"",""items"":[{""id"":61},{""id"":232},{""id"":925}]}" False 2021-07-26 799 697-896-8597
4 5 2023-11-01T12:00:35+00:00 TSHFYITMO 白军 gwgxobwc@hotmail.com 79 159000.0 女 德国 吉林省乌鲁木齐学院路152号5单元1100 "{""average_price"":517.87,""category"":""家居"",""items"":[{""id"":274},{""id"":975},{""id"":904},{""id"":729},{""id"":781},{""id"":882},{""id"":708},{""id"":864},{""id"":632},{""id"":686}]}" False 2021-12-16 706 141-638-9617
2025-03-31 12:00:21,650 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:00:21,689 - INFO - None
2025-03-31 12:00:22,767 - INFO - id age income credit_score
count 10000000.00 10000000.00 10000000.00 10000000.00
mean 49000.50 59.01 499400.43 575.09
std 28850.19 23.95 289011.11 159.01
min 1.00 18.00 0.00 300.00
25% 24039.00 38.00 249000.00 437.00
50% 48077.00 59.00 499000.00 575.00
75% 73959.00 80.00 750000.00 713.00
max 100000.00 100.00 1000000.00 850.00
2025-03-31 12:00:26,425 - INFO - 数据中不存在缺失值
2025-03-31 12:00:26,447 - INFO - 数据中不存在年龄非法值
2025-03-31 12:00:47,716 - WARNING - 数据中性别列存在异常值，异常值数量: 0
2025-03-31 12:00:47,716 - WARNING - 数据中存在重复行，重复行重复量: 8800000
2025-03-31 12:01:34,313 - INFO - 删除重复行后，数据框中已无重复行。
2025-03-31 12:01:46,098 - INFO - 开始执行 cluster_and_analyze 函数
2025-03-31 12:01:46,098 - INFO - 开始提取 purchase_history 中的 average_price 和 items 的长度
2025-03-31 12:01:52,813 - INFO - 提取完成
2025-03-31 12:01:52,817 - INFO - 选择的特征为: ['income', 'average_price', 'items_count']
2025-03-31 12:01:52,818 - INFO - 开始进行数据标准化
2025-03-31 12:01:52,848 - INFO - 数据标准化完成
2025-03-31 12:01:52,849 - INFO - 开始确定最优聚类数
2025-03-31 12:01:52,849 - INFO - 开始尝试聚类数 k = 2
2025-03-31 12:01:53,351 - INFO - 完成聚类数 k = 2 的尝试，当前 SSE: 2763045.5614656797
2025-03-31 12:01:53,352 - INFO - 开始尝试聚类数 k = 3
2025-03-31 12:01:54,104 - INFO - 完成聚类数 k = 3 的尝试，当前 SSE: 2213145.545263183
2025-03-31 12:01:54,104 - INFO - 开始尝试聚类数 k = 4
2025-03-31 12:01:54,778 - INFO - 完成聚类数 k = 4 的尝试，当前 SSE: 1760861.7634280378
2025-03-31 12:01:54,778 - INFO - 开始尝试聚类数 k = 5
2025-03-31 12:01:55,503 - INFO - 完成聚类数 k = 5 的尝试，当前 SSE: 1478082.9969514566
2025-03-31 12:01:55,503 - INFO - 开始尝试聚类数 k = 6
2025-03-31 12:01:56,603 - INFO - 完成聚类数 k = 6 的尝试，当前 SSE: 1227083.5905620966
2025-03-31 12:01:56,603 - INFO - 开始尝试聚类数 k = 7
2025-03-31 12:01:57,333 - INFO - 完成聚类数 k = 7 的尝试，当前 SSE: 1067331.8855758484
2025-03-31 12:01:57,333 - INFO - 开始尝试聚类数 k = 8
2025-03-31 12:01:58,115 - INFO - 完成聚类数 k = 8 的尝试，当前 SSE: 915310.7717410224
2025-03-31 12:01:58,115 - INFO - 开始尝试聚类数 k = 9
2025-03-31 12:01:59,370 - INFO - 完成聚类数 k = 9 的尝试，当前 SSE: 861752.5971240071
2025-03-31 12:01:59,370 - INFO - 开始尝试聚类数 k = 10
2025-03-31 12:02:00,762 - INFO - 完成聚类数 k = 10 的尝试，当前 SSE: 820504.2989924946
2025-03-31 12:02:00,770 - INFO - 最优聚类数 k = 6
2025-03-31 12:02:00,770 - INFO - 开始使用最优聚类数 k = 6 进行 K-means 聚类
2025-03-31 12:02:01,879 - INFO - K-means 聚类完成
2025-03-31 12:02:01,879 - INFO - 开始分析每个聚类的特征
2025-03-31 12:02:01,917 - INFO - 聚类特征分析完成
2025-03-31 12:02:01,917 - INFO - 开始进行 PCA 降维以可视化聚类结果
2025-03-31 12:02:01,953 - INFO - PCA 降维完成
2025-03-31 12:02:01,953 - INFO - 开始绘制散点图可视化聚类结果
2025-03-31 12:02:10,712 - INFO - 将可视化结果保存到 /home/sunminhao/grade8_HOMEWORK/DataMining/Homework1/visualization/cluster_visualization.png
2025-03-31 12:02:56,559 - INFO - 可视化结果保存完成
2025-03-31 12:02:56,559 - INFO - cluster_and_analyze 函数执行结束
2025-03-31 12:02:56,674 - INFO - 每个聚类的特征分析：
2025-03-31 12:02:56,674 - INFO - income average_price items_count is_active
cluster
0 267428.66 695.45 2.75 0.00
1 733337.41 313.94 8.25 0.00
2 786010.05 787.55 4.97 0.00
3 213981.12 222.14 5.98 0.00
4 692904.47 274.13 2.75 0.00
5 308493.38 734.89 8.25 0.00
2025-03-31 12:03:30,617 - INFO - 数据前几行示例:
2025-03-31 12:03:30,619 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-12-20T19:30:36+00:00 xsyxsrvt 廖亮 xxpyxvds@hotmail.com 19 622000.0 男 中国 上海市中山人民路178号3单元1510 "{""average_price"":843.5799999999999,""category"":""电子产品"",""items"":[{""id"":36},{""id"":891},{""id"":420},{""id"":587},{""id"":929},{""id"":940},{""id"":519},{""id"":920},{""id"":621}]}" False 2024-08-18 311 896-131-9026
1 2 2023-12-08T15:55:24+00:00 QILDIW 谢芳 pagkjgxr@hotmail.com 40 20000.0 女 俄罗斯 湖南省乌鲁木齐健康路168号1单元459 "{""average_price"":276.31,""category"":""食品"",""items"":[{""id"":824},{""id"":884},{""id"":732},{""id"":305},{""id"":601},{""id"":754},{""id"":27},{""id"":443}]}" False 2022-03-13 449 936-946-5675
2 3 2025-02-03T20:13:49+00:00 NXMSOJN 蔡秀英 nvdjmyij@gmail.com 60 53000.0 女 澳大利亚 广西壮族自治区中山复兴路61号5单元1912 "{""average_price"":213.94,""category"":""家居"",""items"":[{""id"":793},{""id"":241},{""id"":908},{""id"":887}]}" False 2024-12-01 582 857-179-2343
3 4 2024-05-19T18:33:56+00:00 OKVKJOQA 汪明 dblskeyb@outlook.com 74 271000.0 女 澳大利亚 江苏省石家庄广州路182号3单元2003 "{""average_price"":721.81,""category"":""书籍"",""items"":[{""id"":15},{""id"":522},{""id"":893},{""id"":843},{""id"":156},{""id"":150},{""id"":467},{""id"":378},{""id"":891},{""id"":491}]}" False 2023-03-31 678 841-895-7586
4 5 2023-05-02T09:11:31+00:00 TKZDVTZSN 秦秀英 suskeold@hotmail.com 73 66000.0 男 中国 宁夏回族自治区重庆幸福路117号7单元2367 "{""average_price"":627.76,""category"":""食品"",""items"":[{""id"":348},{""id"":565},{""id"":78},{""id"":792},{""id"":980},{""id"":130},{""id"":977},{""id"":53}]}" False 2020-10-12 671 779-124-4986
2025-03-31 12:03:30,619 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:03:31,926 - INFO - 数据前几行示例:
2025-03-31 12:03:31,951 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-12-30T16:21:57+00:00 fomuwjmlw 江思 lhmqhulm@outlook.com 36 886000.0 女 巴西 青海省合肥广州路57号5单元1213 "{""average_price"":619.84,""category"":""食品"",""items"":[{""id"":411},{""id"":283},{""id"":671},{""id"":464},{""id"":529}]}" False 2022-05-04 424 502-470-3541
1 2 2024-06-29T16:24:59+00:00 FUSAJQR 吕杰 zxundoea@outlook.com 30 226000.0 男 印度 河南省长沙东风路154号3单元1179 "{""average_price"":983.17,""category"":""书籍"",""items"":[{""id"":428},{""id"":449},{""id"":225},{""id"":490},{""id"":220},{""id"":732},{""id"":593},{""id"":108}]}" False 2023-07-05 379 575-654-5232
2 3 2024-05-15T21:10:05+00:00 gvzzkmrc 田嘉 khkwgijh@outlook.com 92 807000.0 女 英国 吉林省金华学院路22号7单元2057 "{""average_price"":750.52,""category"":""电子产品"",""items"":[{""id"":692},{""id"":514},{""id"":852},{""id"":144},{""id"":923},{""id"":561},{""id"":434},{""id"":155}]}" False 2023-03-22 795 793-485-5044
3 4 2023-08-22T16:09:22+00:00 UESELUB 叶磊 wqnjvdue@outlook.com 35 145000.0 男 印度 台湾省南昌工业路170号2单元2317 "{""average_price"":923.7700000000001,""category"":""书籍"",""items"":[{""id"":361},{""id"":410},{""id"":327},{""id"":306},{""id"":782},{""id"":395}]}" False 2021-07-02 414 297-758-6341
4 5 2024-01-01T07:48:21+00:00 GQSUBU 马磊 ddajkaog@163.com 25 136000.0 男 德国 山西省徐州人民路36号6单元1374 "{""average_price"":220.87,""category"":""家居"",""items"":[{""id"":332},{""id"":689},{""id"":371},{""id"":175},{""id"":297},{""id"":599},{""id"":680}]}" False 2022-05-08 351 833-918-3483
2025-03-31 12:03:31,952 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:03:33,316 - INFO - 数据前几行示例:
2025-03-31 12:03:33,342 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-03-22T05:14:02+00:00 ladgtp 唐玲 otdekffb@hotmail.com 61 524000.0 其他 澳大利亚 澳门特别行政区温州新华路148号3单元438 "{""average_price"":921.7900000000001,""category"":""服装"",""items"":[{""id"":134},{""id"":741},{""id"":423},{""id"":141},{""id"":928},{""id"":174}]}" False 2022-11-14 589 593-219-7670
1 2 2023-12-10T11:59:48+00:00 ydbpkymj 潘玲 nisgdysd@hotmail.com 45 526000.0 女 巴西 新疆维吾尔自治区昆明中山路43号1单元634 "{""average_price"":576.28,""category"":""电子产品"",""items"":[{""id"":223}]}" False 2022-03-17 481 935-256-9289
2 3 2023-05-22T08:56:07+00:00 akudv 林宏 wireteca@163.com 20 904000.0 女 澳大利亚 陕西省兰州文化路42号4单元550 "{""average_price"":705.9699999999999,""category"":""电子产品"",""items"":[{""id"":209},{""id"":525},{""id"":188},{""id"":339},{""id"":290}]}" False 2020-11-28 315 290-109-3000
3 4 2023-01-12T16:03:41+00:00 QNQFFFSRS 邱霞 alfsyuaw@qq.com 39 330000.0 男 日本 陕西省杭州友谊路14号1单元1609 "{""average_price"":275.32,""category"":""家居"",""items"":[{""id"":628},{""id"":939}]}" False 2020-01-28 440 709-976-5486
4 5 2023-06-30T17:26:53+00:00 JGAKPKYAT 秦波 ujlxnjww@gmail.com 96 430000.0 男 中国 甘肃省烟台胜利路69号7单元155 "{""average_price"":893.08,""category"":""服装"",""items"":[{""id"":954},{""id"":23},{""id"":493},{""id"":873}]}" False 2021-02-28 820 268-404-3607
2025-03-31 12:03:33,342 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:03:34,717 - INFO - 数据前几行示例:
2025-03-31 12:03:34,744 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-15T02:06:51+00:00 DFPYPK 冯娜 xlbvwqnk@126.com 77 36000.0 女 巴西 青海省绍兴青年路90号1单元241 "{""average_price"":361.45,""category"":""食品"",""items"":[{""id"":466},{""id"":448},{""id"":6},{""id"":59},{""id"":302},{""id"":845},{""id"":386},{""id"":846},{""id"":337},{""id"":617}]}" False 2024-10-16 693 924-519-5030
1 2 2023-01-05T14:43:16+00:00 wzobou 马晓 pqkfyphb@gmail.com 96 714000.0 男 德国 江西省保定北京路123号3单元1336 "{""average_price"":406.99,""category"":""家居"",""items"":[{""id"":542},{""id"":952},{""id"":759},{""id"":615},{""id"":968},{""id"":650},{""id"":459}]}" False 2020-01-11 823 371-860-4475
2 3 2024-11-17T23:59:54+00:00 ftotzea 傅佳 deihadwa@outlook.com 30 841000.0 男 日本 四川省温州平安路152号5单元2424 "{""average_price"":152.56,""category"":""服装"",""items"":[{""id"":233},{""id"":595},{""id"":704},{""id"":279},{""id"":690},{""id"":42},{""id"":752},{""id"":153},{""id"":285},{""id"":716}]}" False 2024-06-01 381 655-419-5633
3 4 2023-10-01T16:58:51+00:00 wwsbbu 马雨 diwflftg@gmail.com 53 950000.0 女 俄罗斯 江西省南通长江路97号7单元659 "{""average_price"":712.9,""category"":""电子产品"",""items"":[{""id"":131},{""id"":281},{""id"":207},{""id"":22}]}" False 2021-10-05 532 644-588-9573
4 5 2024-02-23T13:10:07+00:00 wtbca 杨玲 bxuurmyu@163.com 88 522000.0 男 日本 江苏省南昌人民路150号2单元784 "{""average_price"":489.15999999999997,""category"":""家居"",""items"":[{""id"":37}]}" False 2022-09-10 769 971-685-5134
2025-03-31 12:03:34,744 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:03:36,185 - INFO - 数据前几行示例:
2025-03-31 12:03:36,211 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-07-18T20:47:01+00:00 hcvomsn 阎欣怡 gdbepeeo@qq.com 96 957000.0 女 俄罗斯 广西壮族自治区郑州西湖路30号2单元255 "{""average_price"":73.36,""category"":""服装"",""items"":[{""id"":310},{""id"":149},{""id"":218}]}" False 2021-04-12 822 320-378-2335
1 2 2023-06-27T08:01:35+00:00 qzzqwskj 汪雨 krxwzgui@163.com 83 948000.0 男 美国 台湾省石家庄广州路38号5单元486 "{""average_price"":412.92999999999995,""category"":""服装"",""items"":[{""id"":401},{""id"":191},{""id"":669},{""id"":161},{""id"":116},{""id"":556}]}" False 2021-02-20 736 357-247-8081
2 3 2023-05-14T07:03:05+00:00 MOMJKHJ 蔡娜 zislhnwf@hotmail.com 58 34000.0 男 印度 江西省昆明上海路172号3单元571 "{""average_price"":879.22,""category"":""食品"",""items"":[{""id"":196},{""id"":660},{""id"":587},{""id"":917},{""id"":369}]}" False 2020-11-09 569 271-702-2445
3 4 2023-11-23T05:24:11+00:00 gdpwmam 彭涵 ngjrhsvl@163.com 36 793000.0 女 英国 新疆维吾尔自治区无锡安宁路87号7单元446 "{""average_price"":327.79,""category"":""书籍"",""items"":[{""id"":893},{""id"":807},{""id"":786}]}" False 2022-02-05 424 466-458-4564
4 5 2023-05-11T13:35:04+00:00 jhuwwefsr 江玲 xhqwgvhq@hotmail.com 54 525000.0 女 法国 内蒙古自治区嘉兴西湖路167号2单元599 "{""average_price"":565.3900000000001,""category"":""家居"",""items"":[{""id"":963},{""id"":375},{""id"":308}]}" False 2020-11-02 542 276-694-6283
2025-03-31 12:03:36,211 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:03:37,868 - INFO - 数据前几行示例:
2025-03-31 12:03:37,898 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-09T01:38:20+00:00 UZPFPZJ 彭敏 xtnlkqsb@qq.com 36 73000.0 女 俄罗斯 广西壮族自治区绍兴和谐路152号2单元1384 "{""average_price"":15.940000000000001,""category"":""家居"",""items"":[{""id"":631},{""id"":762},{""id"":233},{""id"":535},{""id"":118},{""id"":449},{""id"":256},{""id"":404},{""id"":99},{""id"":638}]}" False 2024-10-02 423 918-668-7857
1 2 2023-07-08T22:53:52+00:00 UEHSG 高杰 rkpktrqz@outlook.com 58 223000.0 女 巴西 黑龙江省大连建设路127号1单元1835 "{""average_price"":563.4100000000001,""category"":""食品"",""items"":[{""id"":425},{""id"":678},{""id"":72},{""id"":666}]}" False 2021-03-19 567 205-503-3300
2 3 2023-12-31T20:00:57+00:00 fxuujvnk 姜子轩 vwnquvla@outlook.com 88 858000.0 男 美国 浙江省厦门繁荣路15号5单元1442 "{""average_price"":669.34,""category"":""书籍"",""items"":[{""id"":395},{""id"":148},{""id"":731},{""id"":847}]}" False 2022-05-07 767 673-105-7503
3 4 2023-03-22T11:12:02+00:00 DDERCI 梁云 jpajekzz@qq.com 61 485000.0 男 德国 四川省宁波上海路30号6单元2134 "{""average_price"":637.66,""category"":""书籍"",""items"":[{""id"":908},{""id"":793},{""id"":121},{""id"":530},{""id"":826},{""id"":395},{""id"":869},{""id"":510},{""id"":506},{""id"":159}]}" False 2020-07-08 587 387-482-7104
4 5 2024-08-10T11:43:08+00:00 RTABMQKQLG 钱俊 haqlhpmb@163.com 33 437000.0 男 中国 四川省成都康乐路181号6单元391 "{""average_price"":505.0,""category"":""家居"",""items"":[{""id"":307},{""id"":439},{""id"":590},{""id"":16},{""id"":393},{""id"":738},{""id"":65},{""id"":519},{""id"":363}]}" False 2023-10-12 404 602-478-3001
2025-03-31 12:03:37,898 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:03:40,273 - INFO - 数据前几行示例:
2025-03-31 12:03:40,318 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-25T07:15:59+00:00 gtlcuz 于宏 ykxyfhgm@163.com 96 746000.0 男 日本 福建省乌鲁木齐东风路80号6单元2277 "{""average_price"":736.66,""category"":""服装"",""items"":[{""id"":295},{""id"":397},{""id"":798},{""id"":906},{""id"":916},{""id"":953},{""id"":855},{""id"":201},{""id"":140},{""id"":302}]}" False 2024-11-09 819 936-365-4573
1 2 2024-10-10T23:32:13+00:00 nbcpsl 马鹏 vfiteszh@hotmail.com 29 944000.0 男 日本 西藏自治区重庆新华路61号6单元662 "{""average_price"":226.81,""category"":""书籍"",""items"":[{""id"":265},{""id"":459},{""id"":817},{""id"":843},{""id"":128}]}" False 2024-03-04 373 924-957-8702
2 3 2025-02-13T22:44:56+00:00 gsbhu 徐雨 yduzrewc@163.com 36 123000.0 女 澳大利亚 江西省长沙青年路163号6单元407 "{""average_price"":596.0799999999999,""category"":""书籍"",""items"":[{""id"":304},{""id"":181},{""id"":895},{""id"":706},{""id"":832},{""id"":972},{""id"":685},{""id"":305}]}" False 2024-12-25 419 371-760-3106
3 4 2023-04-24T03:46:06+00:00 YAAYX 林强 zutmavfa@163.com 58 132000.0 男 美国 安徽省中山振兴路61号2单元2249 "{""average_price"":494.11,""category"":""书籍"",""items"":[{""id"":732},{""id"":126},{""id"":813},{""id"":783},{""id"":36},{""id"":995},{""id"":15},{""id"":661},{""id"":65},{""id"":191}]}" False 2020-09-22 569 463-338-5133
4 5 2023-07-10T07:48:22+00:00 TAJJHCND 廖强 pvyzvahj@outlook.com 57 278000.0 女 巴西 澳门特别行政区南昌西湖路118号7单元377 "{""average_price"":676.2700000000001,""category"":""电子产品"",""items"":[{""id"":327},{""id"":596},{""id"":59},{""id"":997},{""id"":685},{""id"":804},{""id"":185},{""id"":735},{""id"":126},{""id"":489}]}" False 2021-03-23 564 214-297-9938
2025-03-31 12:03:40,318 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:03:42,133 - INFO - 数据前几行示例:
2025-03-31 12:03:42,159 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-09-11T21:05:26+00:00 xwrnixyn 田亮 tefwjoji@hotmail.com 95 625000.0 男 美国 山西省太原学院路37号7单元594 "{""average_price"":306.01,""category"":""食品"",""items"":[{""id"":579},{""id"":186},{""id"":892},{""id"":206},{""id"":503},{""id"":847},{""id"":830},{""id"":347}]}" False 2023-12-27 813 786-620-2670
1 2 2024-12-26T08:26:10+00:00 cztdqb 董欣 kpfuiggp@126.com 24 932000.0 男 美国 广西壮族自治区东莞东风路115号4单元999 "{""average_price"":667.36,""category"":""书籍"",""items"":[{""id"":341}]}" False 2024-08-31 344 552-862-8469
2 3 2024-11-20T00:24:35+00:00 bebtqxuw 潘红 hxusqnzs@outlook.com 78 538000.0 女 英国 云南省中山兴隆路102号3单元210 "{""average_price"":809.9200000000001,""category"":""书籍"",""items"":[{""id"":46},{""id"":598},{""id"":957},{""id"":209},{""id"":335}]}" False 2024-06-06 701 616-533-4370
3 4 2023-09-01T11:43:33+00:00 QZCNRKTUV 孔敏 sstvzrnr@126.com 93 81000.0 男 日本 吉林省宁波兴华路169号3单元2079 "{""average_price"":600.04,""category"":""家居"",""items"":[{""id"":61},{""id"":232},{""id"":925}]}" False 2021-07-26 799 697-896-8597
4 5 2023-11-01T12:00:35+00:00 TSHFYITMO 白军 gwgxobwc@hotmail.com 79 159000.0 女 德国 吉林省乌鲁木齐学院路152号5单元1100 "{""average_price"":517.87,""category"":""家居"",""items"":[{""id"":274},{""id"":975},{""id"":904},{""id"":729},{""id"":781},{""id"":882},{""id"":708},{""id"":864},{""id"":632},{""id"":686}]}" False 2021-12-16 706 141-638-9617
2025-03-31 12:03:42,159 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:03:42,212 - INFO - None
2025-03-31 12:03:43,305 - INFO - id age income credit_score
count 10000000.00 10000000.00 10000000.00 10000000.00
mean 49000.50 59.01 499400.43 575.09
std 28850.19 23.95 289011.11 159.01
min 1.00 18.00 0.00 300.00
25% 24039.00 38.00 249000.00 437.00
50% 48077.00 59.00 499000.00 575.00
75% 73959.00 80.00 750000.00 713.00
max 100000.00 100.00 1000000.00 850.00
2025-03-31 12:03:47,235 - INFO - 数据中不存在缺失值
2025-03-31 12:03:47,258 - INFO - 数据中不存在年龄非法值
2025-03-31 12:04:06,866 - WARNING - 数据中性别列存在异常值，异常值数量: 0
2025-03-31 12:04:06,866 - WARNING - 数据中存在重复行，重复行重复量: 8800000
2025-03-31 12:04:52,612 - INFO - 删除重复行后，数据框中已无重复行。
2025-03-31 12:05:04,348 - INFO - 开始执行 cluster_and_analyze 函数
2025-03-31 12:05:04,348 - INFO - 开始提取 purchase_history 中的 average_price 和 items 的长度
2025-03-31 12:05:11,344 - INFO - 提取完成
2025-03-31 12:05:11,349 - INFO - 选择的特征为: ['income', 'average_price', 'items_count']
2025-03-31 12:05:11,349 - INFO - 开始进行数据标准化
2025-03-31 12:05:11,383 - INFO - 数据标准化完成
2025-03-31 12:05:11,383 - INFO - 开始确定最优聚类数
2025-03-31 12:05:11,383 - INFO - 开始尝试聚类数 k = 1
2025-03-31 12:05:11,787 - INFO - 完成聚类数 k = 1 的尝试，当前 SSE: 3696024.0
2025-03-31 12:05:11,788 - INFO - 开始尝试聚类数 k = 2
2025-03-31 12:05:12,203 - INFO - 完成聚类数 k = 2 的尝试，当前 SSE: 2763036.6066355635
2025-03-31 12:05:12,203 - INFO - 开始尝试聚类数 k = 3
2025-03-31 12:05:12,874 - INFO - 完成聚类数 k = 3 的尝试，当前 SSE: 2204729.4904332613
2025-03-31 12:05:12,874 - INFO - 开始尝试聚类数 k = 4
2025-03-31 12:05:13,606 - INFO - 完成聚类数 k = 4 的尝试，当前 SSE: 1757554.5531607324
2025-03-31 12:05:13,606 - INFO - 开始尝试聚类数 k = 5
2025-03-31 12:05:14,461 - INFO - 完成聚类数 k = 5 的尝试，当前 SSE: 1476993.2639491213
2025-03-31 12:05:14,461 - INFO - 开始尝试聚类数 k = 6
2025-03-31 12:05:15,078 - INFO - 完成聚类数 k = 6 的尝试，当前 SSE: 1228780.8477730078
2025-03-31 12:05:15,078 - INFO - 开始尝试聚类数 k = 7
2025-03-31 12:05:15,714 - INFO - 完成聚类数 k = 7 的尝试，当前 SSE: 1067347.6849918533
2025-03-31 12:05:15,714 - INFO - 开始尝试聚类数 k = 8
2025-03-31 12:05:16,538 - INFO - 完成聚类数 k = 8 的尝试，当前 SSE: 915315.8554652903
2025-03-31 12:05:16,538 - INFO - 开始尝试聚类数 k = 9
2025-03-31 12:05:17,605 - INFO - 完成聚类数 k = 9 的尝试，当前 SSE: 868140.6034312667
2025-03-31 12:05:17,605 - INFO - 开始尝试聚类数 k = 10
2025-03-31 12:05:19,397 - INFO - 完成聚类数 k = 10 的尝试，当前 SSE: 820404.004089285
2025-03-31 12:05:19,398 - INFO - 开始尝试聚类数 k = 11
2025-03-31 12:05:20,675 - INFO - 完成聚类数 k = 11 的尝试，当前 SSE: 780424.8911530869
2025-03-31 12:05:20,675 - INFO - 开始尝试聚类数 k = 12
2025-03-31 12:05:22,264 - INFO - 完成聚类数 k = 12 的尝试，当前 SSE: 742842.2542203573
2025-03-31 12:05:22,264 - INFO - 开始尝试聚类数 k = 13
2025-03-31 12:05:23,781 - INFO - 完成聚类数 k = 13 的尝试，当前 SSE: 707548.5307092856
2025-03-31 12:05:23,782 - INFO - 开始尝试聚类数 k = 14
2025-03-31 12:05:25,380 - INFO - 完成聚类数 k = 14 的尝试，当前 SSE: 675565.862995775
2025-03-31 12:05:25,380 - INFO - 开始尝试聚类数 k = 15
2025-03-31 12:05:26,528 - INFO - 完成聚类数 k = 15 的尝试，当前 SSE: 645409.5829497626
2025-03-31 12:05:26,528 - INFO - 开始尝试聚类数 k = 16
2025-03-31 12:05:28,410 - INFO - 完成聚类数 k = 16 的尝试，当前 SSE: 606589.1540053991
2025-03-31 12:05:28,410 - INFO - 开始尝试聚类数 k = 17
2025-03-31 12:05:30,216 - INFO - 完成聚类数 k = 17 的尝试，当前 SSE: 580374.1237664488
2025-03-31 12:05:30,216 - INFO - 开始尝试聚类数 k = 18
2025-03-31 12:05:32,099 - INFO - 完成聚类数 k = 18 的尝试，当前 SSE: 559436.3332619373
2025-03-31 12:05:32,099 - INFO - 开始尝试聚类数 k = 19
2025-03-31 12:05:33,523 - INFO - 完成聚类数 k = 19 的尝试，当前 SSE: 538950.8099730427
2025-03-31 12:05:33,532 - INFO - 最优聚类数 k = 10
2025-03-31 12:05:33,532 - INFO - 开始使用最优聚类数 k = 10 进行 K-means 聚类
2025-03-31 12:05:35,407 - INFO - K-means 聚类完成
2025-03-31 12:05:35,407 - INFO - 开始分析每个聚类的特征
2025-03-31 12:05:35,443 - INFO - 聚类特征分析完成
2025-03-31 12:05:35,443 - INFO - 开始进行 PCA 降维以可视化聚类结果
2025-03-31 12:05:35,490 - INFO - PCA 降维完成
2025-03-31 12:05:35,490 - INFO - 开始绘制散点图可视化聚类结果
2025-03-31 12:05:44,309 - INFO - 将可视化结果保存到 /home/sunminhao/grade8_HOMEWORK/DataMining/Homework1/visualization/cluster_visualization.png
2025-03-31 12:06:29,822 - INFO - 可视化结果保存完成
2025-03-31 12:06:29,823 - INFO - cluster_and_analyze 函数执行结束
2025-03-31 12:06:29,943 - INFO - 每个聚类的特征分析：
2025-03-31 12:06:29,943 - INFO - income average_price items_count is_active
cluster
0 462522.56 506.12 5.70 0.00
1 234057.88 769.53 8.15 0.00
2 731072.16 167.62 2.99 0.00
3 227124.18 763.75 2.85 0.00
4 233213.91 240.98 8.16 0.00
5 732738.68 841.58 2.98 0.00
6 762185.29 766.76 8.12 0.00
7 761054.70 242.60 8.12 0.00
8 225477.29 247.11 2.85 0.00
9 790932.58 503.10 2.83 0.00
2025-03-31 12:07:01,213 - INFO - 数据前几行示例:
2025-03-31 12:07:01,215 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-12-20T19:30:36+00:00 xsyxsrvt 廖亮 xxpyxvds@hotmail.com 19 622000.0 男 中国 上海市中山人民路178号3单元1510 "{""average_price"":843.5799999999999,""category"":""电子产品"",""items"":[{""id"":36},{""id"":891},{""id"":420},{""id"":587},{""id"":929},{""id"":940},{""id"":519},{""id"":920},{""id"":621}]}" False 2024-08-18 311 896-131-9026
1 2 2023-12-08T15:55:24+00:00 QILDIW 谢芳 pagkjgxr@hotmail.com 40 20000.0 女 俄罗斯 湖南省乌鲁木齐健康路168号1单元459 "{""average_price"":276.31,""category"":""食品"",""items"":[{""id"":824},{""id"":884},{""id"":732},{""id"":305},{""id"":601},{""id"":754},{""id"":27},{""id"":443}]}" False 2022-03-13 449 936-946-5675
2 3 2025-02-03T20:13:49+00:00 NXMSOJN 蔡秀英 nvdjmyij@gmail.com 60 53000.0 女 澳大利亚 广西壮族自治区中山复兴路61号5单元1912 "{""average_price"":213.94,""category"":""家居"",""items"":[{""id"":793},{""id"":241},{""id"":908},{""id"":887}]}" False 2024-12-01 582 857-179-2343
3 4 2024-05-19T18:33:56+00:00 OKVKJOQA 汪明 dblskeyb@outlook.com 74 271000.0 女 澳大利亚 江苏省石家庄广州路182号3单元2003 "{""average_price"":721.81,""category"":""书籍"",""items"":[{""id"":15},{""id"":522},{""id"":893},{""id"":843},{""id"":156},{""id"":150},{""id"":467},{""id"":378},{""id"":891},{""id"":491}]}" False 2023-03-31 678 841-895-7586
4 5 2023-05-02T09:11:31+00:00 TKZDVTZSN 秦秀英 suskeold@hotmail.com 73 66000.0 男 中国 宁夏回族自治区重庆幸福路117号7单元2367 "{""average_price"":627.76,""category"":""食品"",""items"":[{""id"":348},{""id"":565},{""id"":78},{""id"":792},{""id"":980},{""id"":130},{""id"":977},{""id"":53}]}" False 2020-10-12 671 779-124-4986
2025-03-31 12:07:01,215 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:07:02,433 - INFO - 数据前几行示例:
2025-03-31 12:07:02,458 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-12-30T16:21:57+00:00 fomuwjmlw 江思 lhmqhulm@outlook.com 36 886000.0 女 巴西 青海省合肥广州路57号5单元1213 "{""average_price"":619.84,""category"":""食品"",""items"":[{""id"":411},{""id"":283},{""id"":671},{""id"":464},{""id"":529}]}" False 2022-05-04 424 502-470-3541
1 2 2024-06-29T16:24:59+00:00 FUSAJQR 吕杰 zxundoea@outlook.com 30 226000.0 男 印度 河南省长沙东风路154号3单元1179 "{""average_price"":983.17,""category"":""书籍"",""items"":[{""id"":428},{""id"":449},{""id"":225},{""id"":490},{""id"":220},{""id"":732},{""id"":593},{""id"":108}]}" False 2023-07-05 379 575-654-5232
2 3 2024-05-15T21:10:05+00:00 gvzzkmrc 田嘉 khkwgijh@outlook.com 92 807000.0 女 英国 吉林省金华学院路22号7单元2057 "{""average_price"":750.52,""category"":""电子产品"",""items"":[{""id"":692},{""id"":514},{""id"":852},{""id"":144},{""id"":923},{""id"":561},{""id"":434},{""id"":155}]}" False 2023-03-22 795 793-485-5044
3 4 2023-08-22T16:09:22+00:00 UESELUB 叶磊 wqnjvdue@outlook.com 35 145000.0 男 印度 台湾省南昌工业路170号2单元2317 "{""average_price"":923.7700000000001,""category"":""书籍"",""items"":[{""id"":361},{""id"":410},{""id"":327},{""id"":306},{""id"":782},{""id"":395}]}" False 2021-07-02 414 297-758-6341
4 5 2024-01-01T07:48:21+00:00 GQSUBU 马磊 ddajkaog@163.com 25 136000.0 男 德国 山西省徐州人民路36号6单元1374 "{""average_price"":220.87,""category"":""家居"",""items"":[{""id"":332},{""id"":689},{""id"":371},{""id"":175},{""id"":297},{""id"":599},{""id"":680}]}" False 2022-05-08 351 833-918-3483
2025-03-31 12:07:02,458 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:07:03,788 - INFO - 数据前几行示例:
2025-03-31 12:07:03,813 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-03-22T05:14:02+00:00 ladgtp 唐玲 otdekffb@hotmail.com 61 524000.0 其他 澳大利亚 澳门特别行政区温州新华路148号3单元438 "{""average_price"":921.7900000000001,""category"":""服装"",""items"":[{""id"":134},{""id"":741},{""id"":423},{""id"":141},{""id"":928},{""id"":174}]}" False 2022-11-14 589 593-219-7670
1 2 2023-12-10T11:59:48+00:00 ydbpkymj 潘玲 nisgdysd@hotmail.com 45 526000.0 女 巴西 新疆维吾尔自治区昆明中山路43号1单元634 "{""average_price"":576.28,""category"":""电子产品"",""items"":[{""id"":223}]}" False 2022-03-17 481 935-256-9289
2 3 2023-05-22T08:56:07+00:00 akudv 林宏 wireteca@163.com 20 904000.0 女 澳大利亚 陕西省兰州文化路42号4单元550 "{""average_price"":705.9699999999999,""category"":""电子产品"",""items"":[{""id"":209},{""id"":525},{""id"":188},{""id"":339},{""id"":290}]}" False 2020-11-28 315 290-109-3000
3 4 2023-01-12T16:03:41+00:00 QNQFFFSRS 邱霞 alfsyuaw@qq.com 39 330000.0 男 日本 陕西省杭州友谊路14号1单元1609 "{""average_price"":275.32,""category"":""家居"",""items"":[{""id"":628},{""id"":939}]}" False 2020-01-28 440 709-976-5486
4 5 2023-06-30T17:26:53+00:00 JGAKPKYAT 秦波 ujlxnjww@gmail.com 96 430000.0 男 中国 甘肃省烟台胜利路69号7单元155 "{""average_price"":893.08,""category"":""服装"",""items"":[{""id"":954},{""id"":23},{""id"":493},{""id"":873}]}" False 2021-02-28 820 268-404-3607
2025-03-31 12:07:03,813 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:07:05,196 - INFO - 数据前几行示例:
2025-03-31 12:07:05,224 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-15T02:06:51+00:00 DFPYPK 冯娜 xlbvwqnk@126.com 77 36000.0 女 巴西 青海省绍兴青年路90号1单元241 "{""average_price"":361.45,""category"":""食品"",""items"":[{""id"":466},{""id"":448},{""id"":6},{""id"":59},{""id"":302},{""id"":845},{""id"":386},{""id"":846},{""id"":337},{""id"":617}]}" False 2024-10-16 693 924-519-5030
1 2 2023-01-05T14:43:16+00:00 wzobou 马晓 pqkfyphb@gmail.com 96 714000.0 男 德国 江西省保定北京路123号3单元1336 "{""average_price"":406.99,""category"":""家居"",""items"":[{""id"":542},{""id"":952},{""id"":759},{""id"":615},{""id"":968},{""id"":650},{""id"":459}]}" False 2020-01-11 823 371-860-4475
2 3 2024-11-17T23:59:54+00:00 ftotzea 傅佳 deihadwa@outlook.com 30 841000.0 男 日本 四川省温州平安路152号5单元2424 "{""average_price"":152.56,""category"":""服装"",""items"":[{""id"":233},{""id"":595},{""id"":704},{""id"":279},{""id"":690},{""id"":42},{""id"":752},{""id"":153},{""id"":285},{""id"":716}]}" False 2024-06-01 381 655-419-5633
3 4 2023-10-01T16:58:51+00:00 wwsbbu 马雨 diwflftg@gmail.com 53 950000.0 女 俄罗斯 江西省南通长江路97号7单元659 "{""average_price"":712.9,""category"":""电子产品"",""items"":[{""id"":131},{""id"":281},{""id"":207},{""id"":22}]}" False 2021-10-05 532 644-588-9573
4 5 2024-02-23T13:10:07+00:00 wtbca 杨玲 bxuurmyu@163.com 88 522000.0 男 日本 江苏省南昌人民路150号2单元784 "{""average_price"":489.15999999999997,""category"":""家居"",""items"":[{""id"":37}]}" False 2022-09-10 769 971-685-5134
2025-03-31 12:07:05,225 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:07:06,729 - INFO - 数据前几行示例:
2025-03-31 12:07:06,754 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-07-18T20:47:01+00:00 hcvomsn 阎欣怡 gdbepeeo@qq.com 96 957000.0 女 俄罗斯 广西壮族自治区郑州西湖路30号2单元255 "{""average_price"":73.36,""category"":""服装"",""items"":[{""id"":310},{""id"":149},{""id"":218}]}" False 2021-04-12 822 320-378-2335
1 2 2023-06-27T08:01:35+00:00 qzzqwskj 汪雨 krxwzgui@163.com 83 948000.0 男 美国 台湾省石家庄广州路38号5单元486 "{""average_price"":412.92999999999995,""category"":""服装"",""items"":[{""id"":401},{""id"":191},{""id"":669},{""id"":161},{""id"":116},{""id"":556}]}" False 2021-02-20 736 357-247-8081
2 3 2023-05-14T07:03:05+00:00 MOMJKHJ 蔡娜 zislhnwf@hotmail.com 58 34000.0 男 印度 江西省昆明上海路172号3单元571 "{""average_price"":879.22,""category"":""食品"",""items"":[{""id"":196},{""id"":660},{""id"":587},{""id"":917},{""id"":369}]}" False 2020-11-09 569 271-702-2445
3 4 2023-11-23T05:24:11+00:00 gdpwmam 彭涵 ngjrhsvl@163.com 36 793000.0 女 英国 新疆维吾尔自治区无锡安宁路87号7单元446 "{""average_price"":327.79,""category"":""书籍"",""items"":[{""id"":893},{""id"":807},{""id"":786}]}" False 2022-02-05 424 466-458-4564
4 5 2023-05-11T13:35:04+00:00 jhuwwefsr 江玲 xhqwgvhq@hotmail.com 54 525000.0 女 法国 内蒙古自治区嘉兴西湖路167号2单元599 "{""average_price"":565.3900000000001,""category"":""家居"",""items"":[{""id"":963},{""id"":375},{""id"":308}]}" False 2020-11-02 542 276-694-6283
2025-03-31 12:07:06,754 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:07:08,322 - INFO - 数据前几行示例:
2025-03-31 12:07:08,350 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-09T01:38:20+00:00 UZPFPZJ 彭敏 xtnlkqsb@qq.com 36 73000.0 女 俄罗斯 广西壮族自治区绍兴和谐路152号2单元1384 "{""average_price"":15.940000000000001,""category"":""家居"",""items"":[{""id"":631},{""id"":762},{""id"":233},{""id"":535},{""id"":118},{""id"":449},{""id"":256},{""id"":404},{""id"":99},{""id"":638}]}" False 2024-10-02 423 918-668-7857
1 2 2023-07-08T22:53:52+00:00 UEHSG 高杰 rkpktrqz@outlook.com 58 223000.0 女 巴西 黑龙江省大连建设路127号1单元1835 "{""average_price"":563.4100000000001,""category"":""食品"",""items"":[{""id"":425},{""id"":678},{""id"":72},{""id"":666}]}" False 2021-03-19 567 205-503-3300
2 3 2023-12-31T20:00:57+00:00 fxuujvnk 姜子轩 vwnquvla@outlook.com 88 858000.0 男 美国 浙江省厦门繁荣路15号5单元1442 "{""average_price"":669.34,""category"":""书籍"",""items"":[{""id"":395},{""id"":148},{""id"":731},{""id"":847}]}" False 2022-05-07 767 673-105-7503
3 4 2023-03-22T11:12:02+00:00 DDERCI 梁云 jpajekzz@qq.com 61 485000.0 男 德国 四川省宁波上海路30号6单元2134 "{""average_price"":637.66,""category"":""书籍"",""items"":[{""id"":908},{""id"":793},{""id"":121},{""id"":530},{""id"":826},{""id"":395},{""id"":869},{""id"":510},{""id"":506},{""id"":159}]}" False 2020-07-08 587 387-482-7104
4 5 2024-08-10T11:43:08+00:00 RTABMQKQLG 钱俊 haqlhpmb@163.com 33 437000.0 男 中国 四川省成都康乐路181号6单元391 "{""average_price"":505.0,""category"":""家居"",""items"":[{""id"":307},{""id"":439},{""id"":590},{""id"":16},{""id"":393},{""id"":738},{""id"":65},{""id"":519},{""id"":363}]}" False 2023-10-12 404 602-478-3001
2025-03-31 12:07:08,350 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:07:09,964 - INFO - 数据前几行示例:
2025-03-31 12:07:09,989 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-25T07:15:59+00:00 gtlcuz 于宏 ykxyfhgm@163.com 96 746000.0 男 日本 福建省乌鲁木齐东风路80号6单元2277 "{""average_price"":736.66,""category"":""服装"",""items"":[{""id"":295},{""id"":397},{""id"":798},{""id"":906},{""id"":916},{""id"":953},{""id"":855},{""id"":201},{""id"":140},{""id"":302}]}" False 2024-11-09 819 936-365-4573
1 2 2024-10-10T23:32:13+00:00 nbcpsl 马鹏 vfiteszh@hotmail.com 29 944000.0 男 日本 西藏自治区重庆新华路61号6单元662 "{""average_price"":226.81,""category"":""书籍"",""items"":[{""id"":265},{""id"":459},{""id"":817},{""id"":843},{""id"":128}]}" False 2024-03-04 373 924-957-8702
2 3 2025-02-13T22:44:56+00:00 gsbhu 徐雨 yduzrewc@163.com 36 123000.0 女 澳大利亚 江西省长沙青年路163号6单元407 "{""average_price"":596.0799999999999,""category"":""书籍"",""items"":[{""id"":304},{""id"":181},{""id"":895},{""id"":706},{""id"":832},{""id"":972},{""id"":685},{""id"":305}]}" False 2024-12-25 419 371-760-3106
3 4 2023-04-24T03:46:06+00:00 YAAYX 林强 zutmavfa@163.com 58 132000.0 男 美国 安徽省中山振兴路61号2单元2249 "{""average_price"":494.11,""category"":""书籍"",""items"":[{""id"":732},{""id"":126},{""id"":813},{""id"":783},{""id"":36},{""id"":995},{""id"":15},{""id"":661},{""id"":65},{""id"":191}]}" False 2020-09-22 569 463-338-5133
4 5 2023-07-10T07:48:22+00:00 TAJJHCND 廖强 pvyzvahj@outlook.com 57 278000.0 女 巴西 澳门特别行政区南昌西湖路118号7单元377 "{""average_price"":676.2700000000001,""category"":""电子产品"",""items"":[{""id"":327},{""id"":596},{""id"":59},{""id"":997},{""id"":685},{""id"":804},{""id"":185},{""id"":735},{""id"":126},{""id"":489}]}" False 2021-03-23 564 214-297-9938
2025-03-31 12:07:09,990 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:07:11,805 - INFO - 数据前几行示例:
2025-03-31 12:07:11,840 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-09-11T21:05:26+00:00 xwrnixyn 田亮 tefwjoji@hotmail.com 95 625000.0 男 美国 山西省太原学院路37号7单元594 "{""average_price"":306.01,""category"":""食品"",""items"":[{""id"":579},{""id"":186},{""id"":892},{""id"":206},{""id"":503},{""id"":847},{""id"":830},{""id"":347}]}" False 2023-12-27 813 786-620-2670
1 2 2024-12-26T08:26:10+00:00 cztdqb 董欣 kpfuiggp@126.com 24 932000.0 男 美国 广西壮族自治区东莞东风路115号4单元999 "{""average_price"":667.36,""category"":""书籍"",""items"":[{""id"":341}]}" False 2024-08-31 344 552-862-8469
2 3 2024-11-20T00:24:35+00:00 bebtqxuw 潘红 hxusqnzs@outlook.com 78 538000.0 女 英国 云南省中山兴隆路102号3单元210 "{""average_price"":809.9200000000001,""category"":""书籍"",""items"":[{""id"":46},{""id"":598},{""id"":957},{""id"":209},{""id"":335}]}" False 2024-06-06 701 616-533-4370
3 4 2023-09-01T11:43:33+00:00 QZCNRKTUV 孔敏 sstvzrnr@126.com 93 81000.0 男 日本 吉林省宁波兴华路169号3单元2079 "{""average_price"":600.04,""category"":""家居"",""items"":[{""id"":61},{""id"":232},{""id"":925}]}" False 2021-07-26 799 697-896-8597
4 5 2023-11-01T12:00:35+00:00 TSHFYITMO 白军 gwgxobwc@hotmail.com 79 159000.0 女 德国 吉林省乌鲁木齐学院路152号5单元1100 "{""average_price"":517.87,""category"":""家居"",""items"":[{""id"":274},{""id"":975},{""id"":904},{""id"":729},{""id"":781},{""id"":882},{""id"":708},{""id"":864},{""id"":632},{""id"":686}]}" False 2021-12-16 706 141-638-9617
2025-03-31 12:07:11,840 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:07:11,891 - INFO - None
2025-03-31 12:07:13,028 - INFO - id age income credit_score
count 10000000.00 10000000.00 10000000.00 10000000.00
mean 49000.50 59.01 499400.43 575.09
std 28850.19 23.95 289011.11 159.01
min 1.00 18.00 0.00 300.00
25% 24039.00 38.00 249000.00 437.00
50% 48077.00 59.00 499000.00 575.00
75% 73959.00 80.00 750000.00 713.00
max 100000.00 100.00 1000000.00 850.00
2025-03-31 12:07:16,960 - INFO - 数据中不存在缺失值
2025-03-31 12:07:16,983 - INFO - 数据中不存在年龄非法值
2025-03-31 12:07:36,084 - WARNING - 数据中性别列存在异常值，异常值数量: 0
2025-03-31 12:07:36,085 - WARNING - 数据中存在重复行，重复行重复量: 8800000
2025-03-31 12:08:21,734 - INFO - 删除重复行后，数据框中已无重复行。
2025-03-31 12:08:33,575 - INFO - 开始执行 cluster_and_analyze 函数
2025-03-31 12:08:33,575 - INFO - 开始提取 purchase_history 中的 average_price 和 items 的长度
2025-03-31 12:08:40,158 - INFO - 提取完成
2025-03-31 12:08:40,163 - INFO - 选择的特征为: ['income', 'average_price', 'items_count']
2025-03-31 12:08:40,163 - INFO - 开始进行数据标准化
2025-03-31 12:08:40,194 - INFO - 数据标准化完成
2025-03-31 12:08:40,194 - INFO - 开始确定最优聚类数
2025-03-31 12:08:40,194 - INFO - 开始尝试聚类数 k = 1
2025-03-31 12:08:40,572 - INFO - 完成聚类数 k = 1 的尝试，当前 SSE: 3696027.000000002
2025-03-31 12:08:40,572 - INFO - 开始尝试聚类数 k = 2
2025-03-31 12:08:40,996 - INFO - 完成聚类数 k = 2 的尝试，当前 SSE: 2763037.1983233374
2025-03-31 12:08:40,997 - INFO - 开始尝试聚类数 k = 3
2025-03-31 12:08:41,580 - INFO - 完成聚类数 k = 3 的尝试，当前 SSE: 2208976.311423505
2025-03-31 12:08:41,580 - INFO - 开始尝试聚类数 k = 4
2025-03-31 12:08:42,414 - INFO - 完成聚类数 k = 4 的尝试，当前 SSE: 1760818.847351936
2025-03-31 12:08:42,414 - INFO - 开始尝试聚类数 k = 5
2025-03-31 12:08:43,076 - INFO - 完成聚类数 k = 5 的尝试，当前 SSE: 1500198.151200386
2025-03-31 12:08:43,076 - INFO - 开始尝试聚类数 k = 6
2025-03-31 12:08:43,833 - INFO - 完成聚类数 k = 6 的尝试，当前 SSE: 1227057.9918529987
2025-03-31 12:08:43,833 - INFO - 开始尝试聚类数 k = 7
2025-03-31 12:08:44,551 - INFO - 完成聚类数 k = 7 的尝试，当前 SSE: 1067626.7044581384
2025-03-31 12:08:44,551 - INFO - 开始尝试聚类数 k = 8
2025-03-31 12:08:45,537 - INFO - 完成聚类数 k = 8 的尝试，当前 SSE: 915311.7772644183
2025-03-31 12:08:45,538 - INFO - 开始尝试聚类数 k = 9
2025-03-31 12:08:46,645 - INFO - 完成聚类数 k = 9 的尝试，当前 SSE: 868288.5780368991
2025-03-31 12:08:46,645 - INFO - 开始尝试聚类数 k = 10
2025-03-31 12:08:47,617 - INFO - 完成聚类数 k = 10 的尝试，当前 SSE: 823404.4522938939
2025-03-31 12:08:47,617 - INFO - 开始尝试聚类数 k = 11
2025-03-31 12:08:48,736 - INFO - 完成聚类数 k = 11 的尝试，当前 SSE: 780148.8003365692
2025-03-31 12:08:48,736 - INFO - 开始尝试聚类数 k = 12
2025-03-31 12:08:50,065 - INFO - 完成聚类数 k = 12 的尝试，当前 SSE: 739645.4450139019
2025-03-31 12:08:50,065 - INFO - 开始尝试聚类数 k = 13
2025-03-31 12:08:51,646 - INFO - 完成聚类数 k = 13 的尝试，当前 SSE: 698353.9057713916
2025-03-31 12:08:51,646 - INFO - 开始尝试聚类数 k = 14
2025-03-31 12:08:53,291 - INFO - 完成聚类数 k = 14 的尝试，当前 SSE: 671415.5590404179
2025-03-31 12:08:53,291 - INFO - 开始尝试聚类数 k = 15
2025-03-31 12:08:54,638 - INFO - 完成聚类数 k = 15 的尝试，当前 SSE: 647076.6349017532
2025-03-31 12:08:54,638 - INFO - 开始尝试聚类数 k = 16
2025-03-31 12:08:56,564 - INFO - 完成聚类数 k = 16 的尝试，当前 SSE: 607549.258111763
2025-03-31 12:08:56,564 - INFO - 开始尝试聚类数 k = 17
2025-03-31 12:08:58,559 - INFO - 完成聚类数 k = 17 的尝试，当前 SSE: 581036.8615958766
2025-03-31 12:08:58,560 - INFO - 开始尝试聚类数 k = 18
2025-03-31 12:09:00,435 - INFO - 完成聚类数 k = 18 的尝试，当前 SSE: 557062.1050534218
2025-03-31 12:09:00,436 - INFO - 开始尝试聚类数 k = 19
2025-03-31 12:09:02,099 - INFO - 完成聚类数 k = 19 的尝试，当前 SSE: 538470.9674519366
2025-03-31 12:09:02,100 - INFO - 开始尝试聚类数 k = 20
2025-03-31 12:09:03,951 - INFO - 完成聚类数 k = 20 的尝试，当前 SSE: 515664.2774226492
2025-03-31 12:09:03,952 - INFO - 开始尝试聚类数 k = 21
2025-03-31 12:09:05,989 - INFO - 完成聚类数 k = 21 的尝试，当前 SSE: 498828.66542339185
2025-03-31 12:09:05,989 - INFO - 开始尝试聚类数 k = 22
2025-03-31 12:09:07,704 - INFO - 完成聚类数 k = 22 的尝试，当前 SSE: 483904.8428659191
2025-03-31 12:09:07,704 - INFO - 开始尝试聚类数 k = 23
2025-03-31 12:09:09,442 - INFO - 完成聚类数 k = 23 的尝试，当前 SSE: 466012.55590888014
2025-03-31 12:09:09,443 - INFO - 开始尝试聚类数 k = 24
2025-03-31 12:09:11,600 - INFO - 完成聚类数 k = 24 的尝试，当前 SSE: 449343.8239768657
2025-03-31 12:09:11,697 - INFO - 最优聚类数 k = 10
2025-03-31 12:09:11,697 - INFO - 开始使用最优聚类数 k = 10 进行 K-means 聚类
2025-03-31 12:09:12,635 - INFO - K-means 聚类完成
2025-03-31 12:09:12,635 - INFO - 开始分析每个聚类的特征
2025-03-31 12:09:12,672 - INFO - 聚类特征分析完成
2025-03-31 12:09:12,672 - INFO - 开始进行 PCA 降维以可视化聚类结果
2025-03-31 12:09:12,707 - INFO - PCA 降维完成
2025-03-31 12:09:12,708 - INFO - 开始绘制散点图可视化聚类结果
2025-03-31 12:09:21,223 - INFO - 将可视化结果保存到 /home/sunminhao/grade8_HOMEWORK/DataMining/Homework1/visualization/cluster_visualization.png
2025-03-31 12:10:06,654 - INFO - 可视化结果保存完成
2025-03-31 12:10:06,654 - INFO - cluster_and_analyze 函数执行结束
2025-03-31 12:10:06,772 - INFO - 每个聚类的特征分析：
2025-03-31 12:10:06,773 - INFO - income average_price items_count is_active
cluster
0 236823.01 250.58 2.99 0.00
1 496510.25 745.48 7.86 0.00
2 839204.08 744.27 8.03 0.00
3 160701.05 741.00 8.02 0.00
4 752478.36 241.64 8.04 0.00
5 234779.73 758.18 2.97 0.00
6 684300.19 501.81 3.27 0.00
7 250650.74 247.37 8.00 0.00
8 761226.28 179.89 2.95 0.00
9 764117.87 829.60 2.90 0.00
2025-03-31 12:11:00,115 - INFO - 数据前几行示例:
2025-03-31 12:11:00,116 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-12-20T19:30:36+00:00 xsyxsrvt 廖亮 xxpyxvds@hotmail.com 19 622000.0 男 中国 上海市中山人民路178号3单元1510 "{""average_price"":843.5799999999999,""category"":""电子产品"",""items"":[{""id"":36},{""id"":891},{""id"":420},{""id"":587},{""id"":929},{""id"":940},{""id"":519},{""id"":920},{""id"":621}]}" False 2024-08-18 311 896-131-9026
1 2 2023-12-08T15:55:24+00:00 QILDIW 谢芳 pagkjgxr@hotmail.com 40 20000.0 女 俄罗斯 湖南省乌鲁木齐健康路168号1单元459 "{""average_price"":276.31,""category"":""食品"",""items"":[{""id"":824},{""id"":884},{""id"":732},{""id"":305},{""id"":601},{""id"":754},{""id"":27},{""id"":443}]}" False 2022-03-13 449 936-946-5675
2 3 2025-02-03T20:13:49+00:00 NXMSOJN 蔡秀英 nvdjmyij@gmail.com 60 53000.0 女 澳大利亚 广西壮族自治区中山复兴路61号5单元1912 "{""average_price"":213.94,""category"":""家居"",""items"":[{""id"":793},{""id"":241},{""id"":908},{""id"":887}]}" False 2024-12-01 582 857-179-2343
3 4 2024-05-19T18:33:56+00:00 OKVKJOQA 汪明 dblskeyb@outlook.com 74 271000.0 女 澳大利亚 江苏省石家庄广州路182号3单元2003 "{""average_price"":721.81,""category"":""书籍"",""items"":[{""id"":15},{""id"":522},{""id"":893},{""id"":843},{""id"":156},{""id"":150},{""id"":467},{""id"":378},{""id"":891},{""id"":491}]}" False 2023-03-31 678 841-895-7586
4 5 2023-05-02T09:11:31+00:00 TKZDVTZSN 秦秀英 suskeold@hotmail.com 73 66000.0 男 中国 宁夏回族自治区重庆幸福路117号7单元2367 "{""average_price"":627.76,""category"":""食品"",""items"":[{""id"":348},{""id"":565},{""id"":78},{""id"":792},{""id"":980},{""id"":130},{""id"":977},{""id"":53}]}" False 2020-10-12 671 779-124-4986
2025-03-31 12:11:00,116 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:11:01,350 - INFO - 数据前几行示例:
2025-03-31 12:11:01,384 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-12-30T16:21:57+00:00 fomuwjmlw 江思 lhmqhulm@outlook.com 36 886000.0 女 巴西 青海省合肥广州路57号5单元1213 "{""average_price"":619.84,""category"":""食品"",""items"":[{""id"":411},{""id"":283},{""id"":671},{""id"":464},{""id"":529}]}" False 2022-05-04 424 502-470-3541
1 2 2024-06-29T16:24:59+00:00 FUSAJQR 吕杰 zxundoea@outlook.com 30 226000.0 男 印度 河南省长沙东风路154号3单元1179 "{""average_price"":983.17,""category"":""书籍"",""items"":[{""id"":428},{""id"":449},{""id"":225},{""id"":490},{""id"":220},{""id"":732},{""id"":593},{""id"":108}]}" False 2023-07-05 379 575-654-5232
2 3 2024-05-15T21:10:05+00:00 gvzzkmrc 田嘉 khkwgijh@outlook.com 92 807000.0 女 英国 吉林省金华学院路22号7单元2057 "{""average_price"":750.52,""category"":""电子产品"",""items"":[{""id"":692},{""id"":514},{""id"":852},{""id"":144},{""id"":923},{""id"":561},{""id"":434},{""id"":155}]}" False 2023-03-22 795 793-485-5044
3 4 2023-08-22T16:09:22+00:00 UESELUB 叶磊 wqnjvdue@outlook.com 35 145000.0 男 印度 台湾省南昌工业路170号2单元2317 "{""average_price"":923.7700000000001,""category"":""书籍"",""items"":[{""id"":361},{""id"":410},{""id"":327},{""id"":306},{""id"":782},{""id"":395}]}" False 2021-07-02 414 297-758-6341
4 5 2024-01-01T07:48:21+00:00 GQSUBU 马磊 ddajkaog@163.com 25 136000.0 男 德国 山西省徐州人民路36号6单元1374 "{""average_price"":220.87,""category"":""家居"",""items"":[{""id"":332},{""id"":689},{""id"":371},{""id"":175},{""id"":297},{""id"":599},{""id"":680}]}" False 2022-05-08 351 833-918-3483
2025-03-31 12:11:01,384 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:11:02,823 - INFO - 数据前几行示例:
2025-03-31 12:11:02,854 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-03-22T05:14:02+00:00 ladgtp 唐玲 otdekffb@hotmail.com 61 524000.0 其他 澳大利亚 澳门特别行政区温州新华路148号3单元438 "{""average_price"":921.7900000000001,""category"":""服装"",""items"":[{""id"":134},{""id"":741},{""id"":423},{""id"":141},{""id"":928},{""id"":174}]}" False 2022-11-14 589 593-219-7670
1 2 2023-12-10T11:59:48+00:00 ydbpkymj 潘玲 nisgdysd@hotmail.com 45 526000.0 女 巴西 新疆维吾尔自治区昆明中山路43号1单元634 "{""average_price"":576.28,""category"":""电子产品"",""items"":[{""id"":223}]}" False 2022-03-17 481 935-256-9289
2 3 2023-05-22T08:56:07+00:00 akudv 林宏 wireteca@163.com 20 904000.0 女 澳大利亚 陕西省兰州文化路42号4单元550 "{""average_price"":705.9699999999999,""category"":""电子产品"",""items"":[{""id"":209},{""id"":525},{""id"":188},{""id"":339},{""id"":290}]}" False 2020-11-28 315 290-109-3000
3 4 2023-01-12T16:03:41+00:00 QNQFFFSRS 邱霞 alfsyuaw@qq.com 39 330000.0 男 日本 陕西省杭州友谊路14号1单元1609 "{""average_price"":275.32,""category"":""家居"",""items"":[{""id"":628},{""id"":939}]}" False 2020-01-28 440 709-976-5486
4 5 2023-06-30T17:26:53+00:00 JGAKPKYAT 秦波 ujlxnjww@gmail.com 96 430000.0 男 中国 甘肃省烟台胜利路69号7单元155 "{""average_price"":893.08,""category"":""服装"",""items"":[{""id"":954},{""id"":23},{""id"":493},{""id"":873}]}" False 2021-02-28 820 268-404-3607
2025-03-31 12:11:02,854 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:11:04,339 - INFO - 数据前几行示例:
2025-03-31 12:11:04,380 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-15T02:06:51+00:00 DFPYPK 冯娜 xlbvwqnk@126.com 77 36000.0 女 巴西 青海省绍兴青年路90号1单元241 "{""average_price"":361.45,""category"":""食品"",""items"":[{""id"":466},{""id"":448},{""id"":6},{""id"":59},{""id"":302},{""id"":845},{""id"":386},{""id"":846},{""id"":337},{""id"":617}]}" False 2024-10-16 693 924-519-5030
1 2 2023-01-05T14:43:16+00:00 wzobou 马晓 pqkfyphb@gmail.com 96 714000.0 男 德国 江西省保定北京路123号3单元1336 "{""average_price"":406.99,""category"":""家居"",""items"":[{""id"":542},{""id"":952},{""id"":759},{""id"":615},{""id"":968},{""id"":650},{""id"":459}]}" False 2020-01-11 823 371-860-4475
2 3 2024-11-17T23:59:54+00:00 ftotzea 傅佳 deihadwa@outlook.com 30 841000.0 男 日本 四川省温州平安路152号5单元2424 "{""average_price"":152.56,""category"":""服装"",""items"":[{""id"":233},{""id"":595},{""id"":704},{""id"":279},{""id"":690},{""id"":42},{""id"":752},{""id"":153},{""id"":285},{""id"":716}]}" False 2024-06-01 381 655-419-5633
3 4 2023-10-01T16:58:51+00:00 wwsbbu 马雨 diwflftg@gmail.com 53 950000.0 女 俄罗斯 江西省南通长江路97号7单元659 "{""average_price"":712.9,""category"":""电子产品"",""items"":[{""id"":131},{""id"":281},{""id"":207},{""id"":22}]}" False 2021-10-05 532 644-588-9573
4 5 2024-02-23T13:10:07+00:00 wtbca 杨玲 bxuurmyu@163.com 88 522000.0 男 日本 江苏省南昌人民路150号2单元784 "{""average_price"":489.15999999999997,""category"":""家居"",""items"":[{""id"":37}]}" False 2022-09-10 769 971-685-5134
2025-03-31 12:11:04,380 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:11:05,903 - INFO - 数据前几行示例:
2025-03-31 12:11:05,940 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-07-18T20:47:01+00:00 hcvomsn 阎欣怡 gdbepeeo@qq.com 96 957000.0 女 俄罗斯 广西壮族自治区郑州西湖路30号2单元255 "{""average_price"":73.36,""category"":""服装"",""items"":[{""id"":310},{""id"":149},{""id"":218}]}" False 2021-04-12 822 320-378-2335
1 2 2023-06-27T08:01:35+00:00 qzzqwskj 汪雨 krxwzgui@163.com 83 948000.0 男 美国 台湾省石家庄广州路38号5单元486 "{""average_price"":412.92999999999995,""category"":""服装"",""items"":[{""id"":401},{""id"":191},{""id"":669},{""id"":161},{""id"":116},{""id"":556}]}" False 2021-02-20 736 357-247-8081
2 3 2023-05-14T07:03:05+00:00 MOMJKHJ 蔡娜 zislhnwf@hotmail.com 58 34000.0 男 印度 江西省昆明上海路172号3单元571 "{""average_price"":879.22,""category"":""食品"",""items"":[{""id"":196},{""id"":660},{""id"":587},{""id"":917},{""id"":369}]}" False 2020-11-09 569 271-702-2445
3 4 2023-11-23T05:24:11+00:00 gdpwmam 彭涵 ngjrhsvl@163.com 36 793000.0 女 英国 新疆维吾尔自治区无锡安宁路87号7单元446 "{""average_price"":327.79,""category"":""书籍"",""items"":[{""id"":893},{""id"":807},{""id"":786}]}" False 2022-02-05 424 466-458-4564
4 5 2023-05-11T13:35:04+00:00 jhuwwefsr 江玲 xhqwgvhq@hotmail.com 54 525000.0 女 法国 内蒙古自治区嘉兴西湖路167号2单元599 "{""average_price"":565.3900000000001,""category"":""家居"",""items"":[{""id"":963},{""id"":375},{""id"":308}]}" False 2020-11-02 542 276-694-6283
2025-03-31 12:11:05,940 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:11:07,582 - INFO - 数据前几行示例:
2025-03-31 12:11:07,621 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-09T01:38:20+00:00 UZPFPZJ 彭敏 xtnlkqsb@qq.com 36 73000.0 女 俄罗斯 广西壮族自治区绍兴和谐路152号2单元1384 "{""average_price"":15.940000000000001,""category"":""家居"",""items"":[{""id"":631},{""id"":762},{""id"":233},{""id"":535},{""id"":118},{""id"":449},{""id"":256},{""id"":404},{""id"":99},{""id"":638}]}" False 2024-10-02 423 918-668-7857
1 2 2023-07-08T22:53:52+00:00 UEHSG 高杰 rkpktrqz@outlook.com 58 223000.0 女 巴西 黑龙江省大连建设路127号1单元1835 "{""average_price"":563.4100000000001,""category"":""食品"",""items"":[{""id"":425},{""id"":678},{""id"":72},{""id"":666}]}" False 2021-03-19 567 205-503-3300
2 3 2023-12-31T20:00:57+00:00 fxuujvnk 姜子轩 vwnquvla@outlook.com 88 858000.0 男 美国 浙江省厦门繁荣路15号5单元1442 "{""average_price"":669.34,""category"":""书籍"",""items"":[{""id"":395},{""id"":148},{""id"":731},{""id"":847}]}" False 2022-05-07 767 673-105-7503
3 4 2023-03-22T11:12:02+00:00 DDERCI 梁云 jpajekzz@qq.com 61 485000.0 男 德国 四川省宁波上海路30号6单元2134 "{""average_price"":637.66,""category"":""书籍"",""items"":[{""id"":908},{""id"":793},{""id"":121},{""id"":530},{""id"":826},{""id"":395},{""id"":869},{""id"":510},{""id"":506},{""id"":159}]}" False 2020-07-08 587 387-482-7104
4 5 2024-08-10T11:43:08+00:00 RTABMQKQLG 钱俊 haqlhpmb@163.com 33 437000.0 男 中国 四川省成都康乐路181号6单元391 "{""average_price"":505.0,""category"":""家居"",""items"":[{""id"":307},{""id"":439},{""id"":590},{""id"":16},{""id"":393},{""id"":738},{""id"":65},{""id"":519},{""id"":363}]}" False 2023-10-12 404 602-478-3001
2025-03-31 12:11:07,622 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:11:09,418 - INFO - 数据前几行示例:
2025-03-31 12:11:09,455 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-25T07:15:59+00:00 gtlcuz 于宏 ykxyfhgm@163.com 96 746000.0 男 日本 福建省乌鲁木齐东风路80号6单元2277 "{""average_price"":736.66,""category"":""服装"",""items"":[{""id"":295},{""id"":397},{""id"":798},{""id"":906},{""id"":916},{""id"":953},{""id"":855},{""id"":201},{""id"":140},{""id"":302}]}" False 2024-11-09 819 936-365-4573
1 2 2024-10-10T23:32:13+00:00 nbcpsl 马鹏 vfiteszh@hotmail.com 29 944000.0 男 日本 西藏自治区重庆新华路61号6单元662 "{""average_price"":226.81,""category"":""书籍"",""items"":[{""id"":265},{""id"":459},{""id"":817},{""id"":843},{""id"":128}]}" False 2024-03-04 373 924-957-8702
2 3 2025-02-13T22:44:56+00:00 gsbhu 徐雨 yduzrewc@163.com 36 123000.0 女 澳大利亚 江西省长沙青年路163号6单元407 "{""average_price"":596.0799999999999,""category"":""书籍"",""items"":[{""id"":304},{""id"":181},{""id"":895},{""id"":706},{""id"":832},{""id"":972},{""id"":685},{""id"":305}]}" False 2024-12-25 419 371-760-3106
3 4 2023-04-24T03:46:06+00:00 YAAYX 林强 zutmavfa@163.com 58 132000.0 男 美国 安徽省中山振兴路61号2单元2249 "{""average_price"":494.11,""category"":""书籍"",""items"":[{""id"":732},{""id"":126},{""id"":813},{""id"":783},{""id"":36},{""id"":995},{""id"":15},{""id"":661},{""id"":65},{""id"":191}]}" False 2020-09-22 569 463-338-5133
4 5 2023-07-10T07:48:22+00:00 TAJJHCND 廖强 pvyzvahj@outlook.com 57 278000.0 女 巴西 澳门特别行政区南昌西湖路118号7单元377 "{""average_price"":676.2700000000001,""category"":""电子产品"",""items"":[{""id"":327},{""id"":596},{""id"":59},{""id"":997},{""id"":685},{""id"":804},{""id"":185},{""id"":735},{""id"":126},{""id"":489}]}" False 2021-03-23 564 214-297-9938
2025-03-31 12:11:09,455 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:11:11,448 - INFO - 数据前几行示例:
2025-03-31 12:11:11,485 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-09-11T21:05:26+00:00 xwrnixyn 田亮 tefwjoji@hotmail.com 95 625000.0 男 美国 山西省太原学院路37号7单元594 "{""average_price"":306.01,""category"":""食品"",""items"":[{""id"":579},{""id"":186},{""id"":892},{""id"":206},{""id"":503},{""id"":847},{""id"":830},{""id"":347}]}" False 2023-12-27 813 786-620-2670
1 2 2024-12-26T08:26:10+00:00 cztdqb 董欣 kpfuiggp@126.com 24 932000.0 男 美国 广西壮族自治区东莞东风路115号4单元999 "{""average_price"":667.36,""category"":""书籍"",""items"":[{""id"":341}]}" False 2024-08-31 344 552-862-8469
2 3 2024-11-20T00:24:35+00:00 bebtqxuw 潘红 hxusqnzs@outlook.com 78 538000.0 女 英国 云南省中山兴隆路102号3单元210 "{""average_price"":809.9200000000001,""category"":""书籍"",""items"":[{""id"":46},{""id"":598},{""id"":957},{""id"":209},{""id"":335}]}" False 2024-06-06 701 616-533-4370
3 4 2023-09-01T11:43:33+00:00 QZCNRKTUV 孔敏 sstvzrnr@126.com 93 81000.0 男 日本 吉林省宁波兴华路169号3单元2079 "{""average_price"":600.04,""category"":""家居"",""items"":[{""id"":61},{""id"":232},{""id"":925}]}" False 2021-07-26 799 697-896-8597
4 5 2023-11-01T12:00:35+00:00 TSHFYITMO 白军 gwgxobwc@hotmail.com 79 159000.0 女 德国 吉林省乌鲁木齐学院路152号5单元1100 "{""average_price"":517.87,""category"":""家居"",""items"":[{""id"":274},{""id"":975},{""id"":904},{""id"":729},{""id"":781},{""id"":882},{""id"":708},{""id"":864},{""id"":632},{""id"":686}]}" False 2021-12-16 706 141-638-9617
2025-03-31 12:11:11,485 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:11:11,523 - INFO - None
2025-03-31 12:11:12,611 - INFO - id age income credit_score
count 10000000.00 10000000.00 10000000.00 10000000.00
mean 49000.50 59.01 499400.43 575.09
std 28850.19 23.95 289011.11 159.01
min 1.00 18.00 0.00 300.00
25% 24039.00 38.00 249000.00 437.00
50% 48077.00 59.00 499000.00 575.00
75% 73959.00 80.00 750000.00 713.00
max 100000.00 100.00 1000000.00 850.00
2025-03-31 12:11:16,790 - INFO - 数据中不存在缺失值
2025-03-31 12:11:16,814 - INFO - 数据中不存在年龄非法值
2025-03-31 12:11:37,982 - WARNING - 数据中性别列存在异常值，异常值数量: 0
2025-03-31 12:11:37,982 - WARNING - 数据中存在重复行，重复行重复量: 8800000
2025-03-31 12:12:25,401 - INFO - 删除重复行后，数据框中已无重复行。
2025-03-31 12:12:37,122 - INFO - 开始执行 cluster_and_analyze 函数
2025-03-31 12:12:37,122 - INFO - 开始提取 purchase_history 中的 average_price 和 items 的长度
2025-03-31 12:12:43,706 - INFO - 提取完成
2025-03-31 12:12:43,710 - INFO - 选择的特征为: ['income', 'average_price', 'items_count']
2025-03-31 12:12:43,711 - INFO - 开始进行数据标准化
2025-03-31 12:12:43,742 - INFO - 数据标准化完成
2025-03-31 12:12:43,742 - INFO - 开始确定最优聚类数
2025-03-31 12:12:43,742 - INFO - 开始尝试聚类数 k = 1
2025-03-31 12:12:44,175 - INFO - 完成聚类数 k = 1 的尝试，当前 SSE: 3696026.999999999
2025-03-31 12:12:44,175 - INFO - 开始尝试聚类数 k = 2
2025-03-31 12:12:44,780 - INFO - 完成聚类数 k = 2 的尝试，当前 SSE: 2772327.233913846
2025-03-31 12:12:44,780 - INFO - 开始尝试聚类数 k = 3
2025-03-31 12:12:45,536 - INFO - 完成聚类数 k = 3 的尝试，当前 SSE: 2210428.290275803
2025-03-31 12:12:45,536 - INFO - 开始尝试聚类数 k = 4
2025-03-31 12:12:46,538 - INFO - 完成聚类数 k = 4 的尝试，当前 SSE: 1760934.514811857
2025-03-31 12:12:46,538 - INFO - 开始尝试聚类数 k = 5
2025-03-31 12:12:47,486 - INFO - 完成聚类数 k = 5 的尝试，当前 SSE: 1477159.034301757
2025-03-31 12:12:47,487 - INFO - 开始尝试聚类数 k = 6
2025-03-31 12:12:48,069 - INFO - 完成聚类数 k = 6 的尝试，当前 SSE: 1227506.5796821495
2025-03-31 12:12:48,070 - INFO - 开始尝试聚类数 k = 7
2025-03-31 12:12:48,731 - INFO - 完成聚类数 k = 7 的尝试，当前 SSE: 1067768.7294459944
2025-03-31 12:12:48,731 - INFO - 开始尝试聚类数 k = 8
2025-03-31 12:12:49,724 - INFO - 完成聚类数 k = 8 的尝试，当前 SSE: 915314.9093702373
2025-03-31 12:12:49,724 - INFO - 开始尝试聚类数 k = 9
2025-03-31 12:12:50,662 - INFO - 完成聚类数 k = 9 的尝试，当前 SSE: 868625.9105551702
2025-03-31 12:12:50,662 - INFO - 开始尝试聚类数 k = 10
2025-03-31 12:12:52,167 - INFO - 完成聚类数 k = 10 的尝试，当前 SSE: 819848.877550701
2025-03-31 12:12:52,167 - INFO - 开始尝试聚类数 k = 11
2025-03-31 12:12:53,176 - INFO - 完成聚类数 k = 11 的尝试，当前 SSE: 783154.3012442623
2025-03-31 12:12:53,176 - INFO - 开始尝试聚类数 k = 12
2025-03-31 12:12:54,285 - INFO - 完成聚类数 k = 12 的尝试，当前 SSE: 744283.3533193239
2025-03-31 12:12:54,285 - INFO - 开始尝试聚类数 k = 13
2025-03-31 12:12:55,347 - INFO - 完成聚类数 k = 13 的尝试，当前 SSE: 709038.2233585393
2025-03-31 12:12:55,347 - INFO - 开始尝试聚类数 k = 14
2025-03-31 12:12:57,583 - INFO - 完成聚类数 k = 14 的尝试，当前 SSE: 657598.3384305206
2025-03-31 12:12:57,583 - INFO - 开始尝试聚类数 k = 15
2025-03-31 12:12:59,024 - INFO - 完成聚类数 k = 15 的尝试，当前 SSE: 641413.172817392
2025-03-31 12:12:59,025 - INFO - 开始尝试聚类数 k = 16
2025-03-31 12:13:00,180 - INFO - 完成聚类数 k = 16 的尝试，当前 SSE: 615708.6423335772
2025-03-31 12:13:00,180 - INFO - 开始尝试聚类数 k = 17
2025-03-31 12:13:02,032 - INFO - 完成聚类数 k = 17 的尝试，当前 SSE: 581862.2648966151
2025-03-31 12:13:02,032 - INFO - 开始尝试聚类数 k = 18
2025-03-31 12:13:03,455 - INFO - 完成聚类数 k = 18 的尝试，当前 SSE: 558767.0179474982
2025-03-31 12:13:03,455 - INFO - 开始尝试聚类数 k = 19
2025-03-31 12:13:05,038 - INFO - 完成聚类数 k = 19 的尝试，当前 SSE: 536363.2977842218
2025-03-31 12:13:05,039 - INFO - 开始尝试聚类数 k = 20
2025-03-31 12:13:06,683 - INFO - 完成聚类数 k = 20 的尝试，当前 SSE: 518352.6793424152
2025-03-31 12:13:06,683 - INFO - 开始尝试聚类数 k = 21
2025-03-31 12:13:08,364 - INFO - 完成聚类数 k = 21 的尝试，当前 SSE: 497924.73286695464
2025-03-31 12:13:08,365 - INFO - 开始尝试聚类数 k = 22
2025-03-31 12:13:10,293 - INFO - 完成聚类数 k = 22 的尝试，当前 SSE: 482145.62888326106
2025-03-31 12:13:10,293 - INFO - 开始尝试聚类数 k = 23
2025-03-31 12:13:12,180 - INFO - 完成聚类数 k = 23 的尝试，当前 SSE: 462939.48525438126
2025-03-31 12:13:12,181 - INFO - 开始尝试聚类数 k = 24
2025-03-31 12:13:14,663 - INFO - 完成聚类数 k = 24 的尝试，当前 SSE: 446487.17154511984
2025-03-31 12:13:14,761 - INFO - 最优聚类数 k = 10
2025-03-31 12:13:14,761 - INFO - 开始使用最优聚类数 k = 10 进行 K-means 聚类
2025-03-31 12:13:16,341 - INFO - K-means 聚类完成
2025-03-31 12:13:16,341 - INFO - 开始分析每个聚类的特征
2025-03-31 12:13:16,374 - INFO - 聚类特征分析完成
2025-03-31 12:13:16,374 - INFO - 开始绘制散点图可视化聚类结果
2025-03-31 12:16:06,321 - INFO - 数据前几行示例:
2025-03-31 12:16:06,323 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-12-20T19:30:36+00:00 xsyxsrvt 廖亮 xxpyxvds@hotmail.com 19 622000.0 男 中国 上海市中山人民路178号3单元1510 "{""average_price"":843.5799999999999,""category"":""电子产品"",""items"":[{""id"":36},{""id"":891},{""id"":420},{""id"":587},{""id"":929},{""id"":940},{""id"":519},{""id"":920},{""id"":621}]}" False 2024-08-18 311 896-131-9026
1 2 2023-12-08T15:55:24+00:00 QILDIW 谢芳 pagkjgxr@hotmail.com 40 20000.0 女 俄罗斯 湖南省乌鲁木齐健康路168号1单元459 "{""average_price"":276.31,""category"":""食品"",""items"":[{""id"":824},{""id"":884},{""id"":732},{""id"":305},{""id"":601},{""id"":754},{""id"":27},{""id"":443}]}" False 2022-03-13 449 936-946-5675
2 3 2025-02-03T20:13:49+00:00 NXMSOJN 蔡秀英 nvdjmyij@gmail.com 60 53000.0 女 澳大利亚 广西壮族自治区中山复兴路61号5单元1912 "{""average_price"":213.94,""category"":""家居"",""items"":[{""id"":793},{""id"":241},{""id"":908},{""id"":887}]}" False 2024-12-01 582 857-179-2343
3 4 2024-05-19T18:33:56+00:00 OKVKJOQA 汪明 dblskeyb@outlook.com 74 271000.0 女 澳大利亚 江苏省石家庄广州路182号3单元2003 "{""average_price"":721.81,""category"":""书籍"",""items"":[{""id"":15},{""id"":522},{""id"":893},{""id"":843},{""id"":156},{""id"":150},{""id"":467},{""id"":378},{""id"":891},{""id"":491}]}" False 2023-03-31 678 841-895-7586
4 5 2023-05-02T09:11:31+00:00 TKZDVTZSN 秦秀英 suskeold@hotmail.com 73 66000.0 男 中国 宁夏回族自治区重庆幸福路117号7单元2367 "{""average_price"":627.76,""category"":""食品"",""items"":[{""id"":348},{""id"":565},{""id"":78},{""id"":792},{""id"":980},{""id"":130},{""id"":977},{""id"":53}]}" False 2020-10-12 671 779-124-4986
2025-03-31 12:16:06,323 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:16:07,535 - INFO - 数据前几行示例:
2025-03-31 12:16:07,560 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-12-30T16:21:57+00:00 fomuwjmlw 江思 lhmqhulm@outlook.com 36 886000.0 女 巴西 青海省合肥广州路57号5单元1213 "{""average_price"":619.84,""category"":""食品"",""items"":[{""id"":411},{""id"":283},{""id"":671},{""id"":464},{""id"":529}]}" False 2022-05-04 424 502-470-3541
1 2 2024-06-29T16:24:59+00:00 FUSAJQR 吕杰 zxundoea@outlook.com 30 226000.0 男 印度 河南省长沙东风路154号3单元1179 "{""average_price"":983.17,""category"":""书籍"",""items"":[{""id"":428},{""id"":449},{""id"":225},{""id"":490},{""id"":220},{""id"":732},{""id"":593},{""id"":108}]}" False 2023-07-05 379 575-654-5232
2 3 2024-05-15T21:10:05+00:00 gvzzkmrc 田嘉 khkwgijh@outlook.com 92 807000.0 女 英国 吉林省金华学院路22号7单元2057 "{""average_price"":750.52,""category"":""电子产品"",""items"":[{""id"":692},{""id"":514},{""id"":852},{""id"":144},{""id"":923},{""id"":561},{""id"":434},{""id"":155}]}" False 2023-03-22 795 793-485-5044
3 4 2023-08-22T16:09:22+00:00 UESELUB 叶磊 wqnjvdue@outlook.com 35 145000.0 男 印度 台湾省南昌工业路170号2单元2317 "{""average_price"":923.7700000000001,""category"":""书籍"",""items"":[{""id"":361},{""id"":410},{""id"":327},{""id"":306},{""id"":782},{""id"":395}]}" False 2021-07-02 414 297-758-6341
4 5 2024-01-01T07:48:21+00:00 GQSUBU 马磊 ddajkaog@163.com 25 136000.0 男 德国 山西省徐州人民路36号6单元1374 "{""average_price"":220.87,""category"":""家居"",""items"":[{""id"":332},{""id"":689},{""id"":371},{""id"":175},{""id"":297},{""id"":599},{""id"":680}]}" False 2022-05-08 351 833-918-3483
2025-03-31 12:16:07,560 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:16:08,977 - INFO - 数据前几行示例:
2025-03-31 12:16:09,002 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-03-22T05:14:02+00:00 ladgtp 唐玲 otdekffb@hotmail.com 61 524000.0 其他 澳大利亚 澳门特别行政区温州新华路148号3单元438 "{""average_price"":921.7900000000001,""category"":""服装"",""items"":[{""id"":134},{""id"":741},{""id"":423},{""id"":141},{""id"":928},{""id"":174}]}" False 2022-11-14 589 593-219-7670
1 2 2023-12-10T11:59:48+00:00 ydbpkymj 潘玲 nisgdysd@hotmail.com 45 526000.0 女 巴西 新疆维吾尔自治区昆明中山路43号1单元634 "{""average_price"":576.28,""category"":""电子产品"",""items"":[{""id"":223}]}" False 2022-03-17 481 935-256-9289
2 3 2023-05-22T08:56:07+00:00 akudv 林宏 wireteca@163.com 20 904000.0 女 澳大利亚 陕西省兰州文化路42号4单元550 "{""average_price"":705.9699999999999,""category"":""电子产品"",""items"":[{""id"":209},{""id"":525},{""id"":188},{""id"":339},{""id"":290}]}" False 2020-11-28 315 290-109-3000
3 4 2023-01-12T16:03:41+00:00 QNQFFFSRS 邱霞 alfsyuaw@qq.com 39 330000.0 男 日本 陕西省杭州友谊路14号1单元1609 "{""average_price"":275.32,""category"":""家居"",""items"":[{""id"":628},{""id"":939}]}" False 2020-01-28 440 709-976-5486
4 5 2023-06-30T17:26:53+00:00 JGAKPKYAT 秦波 ujlxnjww@gmail.com 96 430000.0 男 中国 甘肃省烟台胜利路69号7单元155 "{""average_price"":893.08,""category"":""服装"",""items"":[{""id"":954},{""id"":23},{""id"":493},{""id"":873}]}" False 2021-02-28 820 268-404-3607
2025-03-31 12:16:09,003 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:16:10,411 - INFO - 数据前几行示例:
2025-03-31 12:16:10,440 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-15T02:06:51+00:00 DFPYPK 冯娜 xlbvwqnk@126.com 77 36000.0 女 巴西 青海省绍兴青年路90号1单元241 "{""average_price"":361.45,""category"":""食品"",""items"":[{""id"":466},{""id"":448},{""id"":6},{""id"":59},{""id"":302},{""id"":845},{""id"":386},{""id"":846},{""id"":337},{""id"":617}]}" False 2024-10-16 693 924-519-5030
1 2 2023-01-05T14:43:16+00:00 wzobou 马晓 pqkfyphb@gmail.com 96 714000.0 男 德国 江西省保定北京路123号3单元1336 "{""average_price"":406.99,""category"":""家居"",""items"":[{""id"":542},{""id"":952},{""id"":759},{""id"":615},{""id"":968},{""id"":650},{""id"":459}]}" False 2020-01-11 823 371-860-4475
2 3 2024-11-17T23:59:54+00:00 ftotzea 傅佳 deihadwa@outlook.com 30 841000.0 男 日本 四川省温州平安路152号5单元2424 "{""average_price"":152.56,""category"":""服装"",""items"":[{""id"":233},{""id"":595},{""id"":704},{""id"":279},{""id"":690},{""id"":42},{""id"":752},{""id"":153},{""id"":285},{""id"":716}]}" False 2024-06-01 381 655-419-5633
3 4 2023-10-01T16:58:51+00:00 wwsbbu 马雨 diwflftg@gmail.com 53 950000.0 女 俄罗斯 江西省南通长江路97号7单元659 "{""average_price"":712.9,""category"":""电子产品"",""items"":[{""id"":131},{""id"":281},{""id"":207},{""id"":22}]}" False 2021-10-05 532 644-588-9573
4 5 2024-02-23T13:10:07+00:00 wtbca 杨玲 bxuurmyu@163.com 88 522000.0 男 日本 江苏省南昌人民路150号2单元784 "{""average_price"":489.15999999999997,""category"":""家居"",""items"":[{""id"":37}]}" False 2022-09-10 769 971-685-5134
2025-03-31 12:16:10,440 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:16:11,943 - INFO - 数据前几行示例:
2025-03-31 12:16:11,972 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-07-18T20:47:01+00:00 hcvomsn 阎欣怡 gdbepeeo@qq.com 96 957000.0 女 俄罗斯 广西壮族自治区郑州西湖路30号2单元255 "{""average_price"":73.36,""category"":""服装"",""items"":[{""id"":310},{""id"":149},{""id"":218}]}" False 2021-04-12 822 320-378-2335
1 2 2023-06-27T08:01:35+00:00 qzzqwskj 汪雨 krxwzgui@163.com 83 948000.0 男 美国 台湾省石家庄广州路38号5单元486 "{""average_price"":412.92999999999995,""category"":""服装"",""items"":[{""id"":401},{""id"":191},{""id"":669},{""id"":161},{""id"":116},{""id"":556}]}" False 2021-02-20 736 357-247-8081
2 3 2023-05-14T07:03:05+00:00 MOMJKHJ 蔡娜 zislhnwf@hotmail.com 58 34000.0 男 印度 江西省昆明上海路172号3单元571 "{""average_price"":879.22,""category"":""食品"",""items"":[{""id"":196},{""id"":660},{""id"":587},{""id"":917},{""id"":369}]}" False 2020-11-09 569 271-702-2445
3 4 2023-11-23T05:24:11+00:00 gdpwmam 彭涵 ngjrhsvl@163.com 36 793000.0 女 英国 新疆维吾尔自治区无锡安宁路87号7单元446 "{""average_price"":327.79,""category"":""书籍"",""items"":[{""id"":893},{""id"":807},{""id"":786}]}" False 2022-02-05 424 466-458-4564
4 5 2023-05-11T13:35:04+00:00 jhuwwefsr 江玲 xhqwgvhq@hotmail.com 54 525000.0 女 法国 内蒙古自治区嘉兴西湖路167号2单元599 "{""average_price"":565.3900000000001,""category"":""家居"",""items"":[{""id"":963},{""id"":375},{""id"":308}]}" False 2020-11-02 542 276-694-6283
2025-03-31 12:16:11,972 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:16:13,615 - INFO - 数据前几行示例:
2025-03-31 12:16:13,639 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-09T01:38:20+00:00 UZPFPZJ 彭敏 xtnlkqsb@qq.com 36 73000.0 女 俄罗斯 广西壮族自治区绍兴和谐路152号2单元1384 "{""average_price"":15.940000000000001,""category"":""家居"",""items"":[{""id"":631},{""id"":762},{""id"":233},{""id"":535},{""id"":118},{""id"":449},{""id"":256},{""id"":404},{""id"":99},{""id"":638}]}" False 2024-10-02 423 918-668-7857
1 2 2023-07-08T22:53:52+00:00 UEHSG 高杰 rkpktrqz@outlook.com 58 223000.0 女 巴西 黑龙江省大连建设路127号1单元1835 "{""average_price"":563.4100000000001,""category"":""食品"",""items"":[{""id"":425},{""id"":678},{""id"":72},{""id"":666}]}" False 2021-03-19 567 205-503-3300
2 3 2023-12-31T20:00:57+00:00 fxuujvnk 姜子轩 vwnquvla@outlook.com 88 858000.0 男 美国 浙江省厦门繁荣路15号5单元1442 "{""average_price"":669.34,""category"":""书籍"",""items"":[{""id"":395},{""id"":148},{""id"":731},{""id"":847}]}" False 2022-05-07 767 673-105-7503
3 4 2023-03-22T11:12:02+00:00 DDERCI 梁云 jpajekzz@qq.com 61 485000.0 男 德国 四川省宁波上海路30号6单元2134 "{""average_price"":637.66,""category"":""书籍"",""items"":[{""id"":908},{""id"":793},{""id"":121},{""id"":530},{""id"":826},{""id"":395},{""id"":869},{""id"":510},{""id"":506},{""id"":159}]}" False 2020-07-08 587 387-482-7104
4 5 2024-08-10T11:43:08+00:00 RTABMQKQLG 钱俊 haqlhpmb@163.com 33 437000.0 男 中国 四川省成都康乐路181号6单元391 "{""average_price"":505.0,""category"":""家居"",""items"":[{""id"":307},{""id"":439},{""id"":590},{""id"":16},{""id"":393},{""id"":738},{""id"":65},{""id"":519},{""id"":363}]}" False 2023-10-12 404 602-478-3001
2025-03-31 12:16:13,639 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:16:15,320 - INFO - 数据前几行示例:
2025-03-31 12:16:15,345 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-25T07:15:59+00:00 gtlcuz 于宏 ykxyfhgm@163.com 96 746000.0 男 日本 福建省乌鲁木齐东风路80号6单元2277 "{""average_price"":736.66,""category"":""服装"",""items"":[{""id"":295},{""id"":397},{""id"":798},{""id"":906},{""id"":916},{""id"":953},{""id"":855},{""id"":201},{""id"":140},{""id"":302}]}" False 2024-11-09 819 936-365-4573
1 2 2024-10-10T23:32:13+00:00 nbcpsl 马鹏 vfiteszh@hotmail.com 29 944000.0 男 日本 西藏自治区重庆新华路61号6单元662 "{""average_price"":226.81,""category"":""书籍"",""items"":[{""id"":265},{""id"":459},{""id"":817},{""id"":843},{""id"":128}]}" False 2024-03-04 373 924-957-8702
2 3 2025-02-13T22:44:56+00:00 gsbhu 徐雨 yduzrewc@163.com 36 123000.0 女 澳大利亚 江西省长沙青年路163号6单元407 "{""average_price"":596.0799999999999,""category"":""书籍"",""items"":[{""id"":304},{""id"":181},{""id"":895},{""id"":706},{""id"":832},{""id"":972},{""id"":685},{""id"":305}]}" False 2024-12-25 419 371-760-3106
3 4 2023-04-24T03:46:06+00:00 YAAYX 林强 zutmavfa@163.com 58 132000.0 男 美国 安徽省中山振兴路61号2单元2249 "{""average_price"":494.11,""category"":""书籍"",""items"":[{""id"":732},{""id"":126},{""id"":813},{""id"":783},{""id"":36},{""id"":995},{""id"":15},{""id"":661},{""id"":65},{""id"":191}]}" False 2020-09-22 569 463-338-5133
4 5 2023-07-10T07:48:22+00:00 TAJJHCND 廖强 pvyzvahj@outlook.com 57 278000.0 女 巴西 澳门特别行政区南昌西湖路118号7单元377 "{""average_price"":676.2700000000001,""category"":""电子产品"",""items"":[{""id"":327},{""id"":596},{""id"":59},{""id"":997},{""id"":685},{""id"":804},{""id"":185},{""id"":735},{""id"":126},{""id"":489}]}" False 2021-03-23 564 214-297-9938
2025-03-31 12:16:15,346 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:16:17,248 - INFO - 数据前几行示例:
2025-03-31 12:16:17,277 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-09-11T21:05:26+00:00 xwrnixyn 田亮 tefwjoji@hotmail.com 95 625000.0 男 美国 山西省太原学院路37号7单元594 "{""average_price"":306.01,""category"":""食品"",""items"":[{""id"":579},{""id"":186},{""id"":892},{""id"":206},{""id"":503},{""id"":847},{""id"":830},{""id"":347}]}" False 2023-12-27 813 786-620-2670
1 2 2024-12-26T08:26:10+00:00 cztdqb 董欣 kpfuiggp@126.com 24 932000.0 男 美国 广西壮族自治区东莞东风路115号4单元999 "{""average_price"":667.36,""category"":""书籍"",""items"":[{""id"":341}]}" False 2024-08-31 344 552-862-8469
2 3 2024-11-20T00:24:35+00:00 bebtqxuw 潘红 hxusqnzs@outlook.com 78 538000.0 女 英国 云南省中山兴隆路102号3单元210 "{""average_price"":809.9200000000001,""category"":""书籍"",""items"":[{""id"":46},{""id"":598},{""id"":957},{""id"":209},{""id"":335}]}" False 2024-06-06 701 616-533-4370
3 4 2023-09-01T11:43:33+00:00 QZCNRKTUV 孔敏 sstvzrnr@126.com 93 81000.0 男 日本 吉林省宁波兴华路169号3单元2079 "{""average_price"":600.04,""category"":""家居"",""items"":[{""id"":61},{""id"":232},{""id"":925}]}" False 2021-07-26 799 697-896-8597
4 5 2023-11-01T12:00:35+00:00 TSHFYITMO 白军 gwgxobwc@hotmail.com 79 159000.0 女 德国 吉林省乌鲁木齐学院路152号5单元1100 "{""average_price"":517.87,""category"":""家居"",""items"":[{""id"":274},{""id"":975},{""id"":904},{""id"":729},{""id"":781},{""id"":882},{""id"":708},{""id"":864},{""id"":632},{""id"":686}]}" False 2021-12-16 706 141-638-9617
2025-03-31 12:16:17,277 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:16:17,316 - INFO - None
2025-03-31 12:16:18,501 - INFO - id age income credit_score
count 10000000.00 10000000.00 10000000.00 10000000.00
mean 49000.50 59.01 499400.43 575.09
std 28850.19 23.95 289011.11 159.01
min 1.00 18.00 0.00 300.00
25% 24039.00 38.00 249000.00 437.00
50% 48077.00 59.00 499000.00 575.00
75% 73959.00 80.00 750000.00 713.00
max 100000.00 100.00 1000000.00 850.00
2025-03-31 12:16:22,407 - INFO - 数据中不存在缺失值
2025-03-31 12:16:22,445 - INFO - 数据中不存在年龄非法值
2025-03-31 12:16:44,110 - WARNING - 数据中性别列存在异常值，异常值数量: 0
2025-03-31 12:16:44,110 - WARNING - 数据中存在重复行，重复行重复量: 8800000
2025-03-31 12:17:35,406 - INFO - 删除重复行后，数据框中已无重复行。
2025-03-31 12:17:47,208 - INFO - 开始执行 cluster_and_analyze 函数
2025-03-31 12:17:47,209 - INFO - 开始提取 purchase_history 中的 average_price 和 items 的长度
2025-03-31 12:17:54,288 - INFO - 提取完成
2025-03-31 12:17:54,293 - INFO - 选择的特征为: ['income', 'average_price', 'items_count']
2025-03-31 12:17:54,293 - INFO - 开始进行数据标准化
2025-03-31 12:17:54,327 - INFO - 数据标准化完成
2025-03-31 12:17:54,328 - INFO - 最优聚类数 k = 8
2025-03-31 12:17:54,328 - INFO - 开始使用最优聚类数 k = 8 进行 K-means 聚类
2025-03-31 12:17:55,138 - INFO - K-means 聚类完成
2025-03-31 12:17:55,139 - INFO - 开始分析每个聚类的特征
2025-03-31 12:17:55,171 - INFO - 聚类特征分析完成
2025-03-31 12:17:55,172 - INFO - 开始绘制散点图可视化聚类结果
2025-03-31 12:18:37,494 - INFO - 数据前几行示例:
2025-03-31 12:18:37,495 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-12-20T19:30:36+00:00 xsyxsrvt 廖亮 xxpyxvds@hotmail.com 19 622000.0 男 中国 上海市中山人民路178号3单元1510 "{""average_price"":843.5799999999999,""category"":""电子产品"",""items"":[{""id"":36},{""id"":891},{""id"":420},{""id"":587},{""id"":929},{""id"":940},{""id"":519},{""id"":920},{""id"":621}]}" False 2024-08-18 311 896-131-9026
1 2 2023-12-08T15:55:24+00:00 QILDIW 谢芳 pagkjgxr@hotmail.com 40 20000.0 女 俄罗斯 湖南省乌鲁木齐健康路168号1单元459 "{""average_price"":276.31,""category"":""食品"",""items"":[{""id"":824},{""id"":884},{""id"":732},{""id"":305},{""id"":601},{""id"":754},{""id"":27},{""id"":443}]}" False 2022-03-13 449 936-946-5675
2 3 2025-02-03T20:13:49+00:00 NXMSOJN 蔡秀英 nvdjmyij@gmail.com 60 53000.0 女 澳大利亚 广西壮族自治区中山复兴路61号5单元1912 "{""average_price"":213.94,""category"":""家居"",""items"":[{""id"":793},{""id"":241},{""id"":908},{""id"":887}]}" False 2024-12-01 582 857-179-2343
3 4 2024-05-19T18:33:56+00:00 OKVKJOQA 汪明 dblskeyb@outlook.com 74 271000.0 女 澳大利亚 江苏省石家庄广州路182号3单元2003 "{""average_price"":721.81,""category"":""书籍"",""items"":[{""id"":15},{""id"":522},{""id"":893},{""id"":843},{""id"":156},{""id"":150},{""id"":467},{""id"":378},{""id"":891},{""id"":491}]}" False 2023-03-31 678 841-895-7586
4 5 2023-05-02T09:11:31+00:00 TKZDVTZSN 秦秀英 suskeold@hotmail.com 73 66000.0 男 中国 宁夏回族自治区重庆幸福路117号7单元2367 "{""average_price"":627.76,""category"":""食品"",""items"":[{""id"":348},{""id"":565},{""id"":78},{""id"":792},{""id"":980},{""id"":130},{""id"":977},{""id"":53}]}" False 2020-10-12 671 779-124-4986
2025-03-31 12:18:37,495 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:18:38,757 - INFO - 数据前几行示例:
2025-03-31 12:18:38,782 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-12-30T16:21:57+00:00 fomuwjmlw 江思 lhmqhulm@outlook.com 36 886000.0 女 巴西 青海省合肥广州路57号5单元1213 "{""average_price"":619.84,""category"":""食品"",""items"":[{""id"":411},{""id"":283},{""id"":671},{""id"":464},{""id"":529}]}" False 2022-05-04 424 502-470-3541
1 2 2024-06-29T16:24:59+00:00 FUSAJQR 吕杰 zxundoea@outlook.com 30 226000.0 男 印度 河南省长沙东风路154号3单元1179 "{""average_price"":983.17,""category"":""书籍"",""items"":[{""id"":428},{""id"":449},{""id"":225},{""id"":490},{""id"":220},{""id"":732},{""id"":593},{""id"":108}]}" False 2023-07-05 379 575-654-5232
2 3 2024-05-15T21:10:05+00:00 gvzzkmrc 田嘉 khkwgijh@outlook.com 92 807000.0 女 英国 吉林省金华学院路22号7单元2057 "{""average_price"":750.52,""category"":""电子产品"",""items"":[{""id"":692},{""id"":514},{""id"":852},{""id"":144},{""id"":923},{""id"":561},{""id"":434},{""id"":155}]}" False 2023-03-22 795 793-485-5044
3 4 2023-08-22T16:09:22+00:00 UESELUB 叶磊 wqnjvdue@outlook.com 35 145000.0 男 印度 台湾省南昌工业路170号2单元2317 "{""average_price"":923.7700000000001,""category"":""书籍"",""items"":[{""id"":361},{""id"":410},{""id"":327},{""id"":306},{""id"":782},{""id"":395}]}" False 2021-07-02 414 297-758-6341
4 5 2024-01-01T07:48:21+00:00 GQSUBU 马磊 ddajkaog@163.com 25 136000.0 男 德国 山西省徐州人民路36号6单元1374 "{""average_price"":220.87,""category"":""家居"",""items"":[{""id"":332},{""id"":689},{""id"":371},{""id"":175},{""id"":297},{""id"":599},{""id"":680}]}" False 2022-05-08 351 833-918-3483
2025-03-31 12:18:38,782 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:18:40,223 - INFO - 数据前几行示例:
2025-03-31 12:18:40,249 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-03-22T05:14:02+00:00 ladgtp 唐玲 otdekffb@hotmail.com 61 524000.0 其他 澳大利亚 澳门特别行政区温州新华路148号3单元438 "{""average_price"":921.7900000000001,""category"":""服装"",""items"":[{""id"":134},{""id"":741},{""id"":423},{""id"":141},{""id"":928},{""id"":174}]}" False 2022-11-14 589 593-219-7670
1 2 2023-12-10T11:59:48+00:00 ydbpkymj 潘玲 nisgdysd@hotmail.com 45 526000.0 女 巴西 新疆维吾尔自治区昆明中山路43号1单元634 "{""average_price"":576.28,""category"":""电子产品"",""items"":[{""id"":223}]}" False 2022-03-17 481 935-256-9289
2 3 2023-05-22T08:56:07+00:00 akudv 林宏 wireteca@163.com 20 904000.0 女 澳大利亚 陕西省兰州文化路42号4单元550 "{""average_price"":705.9699999999999,""category"":""电子产品"",""items"":[{""id"":209},{""id"":525},{""id"":188},{""id"":339},{""id"":290}]}" False 2020-11-28 315 290-109-3000
3 4 2023-01-12T16:03:41+00:00 QNQFFFSRS 邱霞 alfsyuaw@qq.com 39 330000.0 男 日本 陕西省杭州友谊路14号1单元1609 "{""average_price"":275.32,""category"":""家居"",""items"":[{""id"":628},{""id"":939}]}" False 2020-01-28 440 709-976-5486
4 5 2023-06-30T17:26:53+00:00 JGAKPKYAT 秦波 ujlxnjww@gmail.com 96 430000.0 男 中国 甘肃省烟台胜利路69号7单元155 "{""average_price"":893.08,""category"":""服装"",""items"":[{""id"":954},{""id"":23},{""id"":493},{""id"":873}]}" False 2021-02-28 820 268-404-3607
2025-03-31 12:18:40,249 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:18:41,749 - INFO - 数据前几行示例:
2025-03-31 12:18:41,777 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-15T02:06:51+00:00 DFPYPK 冯娜 xlbvwqnk@126.com 77 36000.0 女 巴西 青海省绍兴青年路90号1单元241 "{""average_price"":361.45,""category"":""食品"",""items"":[{""id"":466},{""id"":448},{""id"":6},{""id"":59},{""id"":302},{""id"":845},{""id"":386},{""id"":846},{""id"":337},{""id"":617}]}" False 2024-10-16 693 924-519-5030
1 2 2023-01-05T14:43:16+00:00 wzobou 马晓 pqkfyphb@gmail.com 96 714000.0 男 德国 江西省保定北京路123号3单元1336 "{""average_price"":406.99,""category"":""家居"",""items"":[{""id"":542},{""id"":952},{""id"":759},{""id"":615},{""id"":968},{""id"":650},{""id"":459}]}" False 2020-01-11 823 371-860-4475
2 3 2024-11-17T23:59:54+00:00 ftotzea 傅佳 deihadwa@outlook.com 30 841000.0 男 日本 四川省温州平安路152号5单元2424 "{""average_price"":152.56,""category"":""服装"",""items"":[{""id"":233},{""id"":595},{""id"":704},{""id"":279},{""id"":690},{""id"":42},{""id"":752},{""id"":153},{""id"":285},{""id"":716}]}" False 2024-06-01 381 655-419-5633
3 4 2023-10-01T16:58:51+00:00 wwsbbu 马雨 diwflftg@gmail.com 53 950000.0 女 俄罗斯 江西省南通长江路97号7单元659 "{""average_price"":712.9,""category"":""电子产品"",""items"":[{""id"":131},{""id"":281},{""id"":207},{""id"":22}]}" False 2021-10-05 532 644-588-9573
4 5 2024-02-23T13:10:07+00:00 wtbca 杨玲 bxuurmyu@163.com 88 522000.0 男 日本 江苏省南昌人民路150号2单元784 "{""average_price"":489.15999999999997,""category"":""家居"",""items"":[{""id"":37}]}" False 2022-09-10 769 971-685-5134
2025-03-31 12:18:41,777 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:18:43,398 - INFO - 数据前几行示例:
2025-03-31 12:18:43,424 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-07-18T20:47:01+00:00 hcvomsn 阎欣怡 gdbepeeo@qq.com 96 957000.0 女 俄罗斯 广西壮族自治区郑州西湖路30号2单元255 "{""average_price"":73.36,""category"":""服装"",""items"":[{""id"":310},{""id"":149},{""id"":218}]}" False 2021-04-12 822 320-378-2335
1 2 2023-06-27T08:01:35+00:00 qzzqwskj 汪雨 krxwzgui@163.com 83 948000.0 男 美国 台湾省石家庄广州路38号5单元486 "{""average_price"":412.92999999999995,""category"":""服装"",""items"":[{""id"":401},{""id"":191},{""id"":669},{""id"":161},{""id"":116},{""id"":556}]}" False 2021-02-20 736 357-247-8081
2 3 2023-05-14T07:03:05+00:00 MOMJKHJ 蔡娜 zislhnwf@hotmail.com 58 34000.0 男 印度 江西省昆明上海路172号3单元571 "{""average_price"":879.22,""category"":""食品"",""items"":[{""id"":196},{""id"":660},{""id"":587},{""id"":917},{""id"":369}]}" False 2020-11-09 569 271-702-2445
3 4 2023-11-23T05:24:11+00:00 gdpwmam 彭涵 ngjrhsvl@163.com 36 793000.0 女 英国 新疆维吾尔自治区无锡安宁路87号7单元446 "{""average_price"":327.79,""category"":""书籍"",""items"":[{""id"":893},{""id"":807},{""id"":786}]}" False 2022-02-05 424 466-458-4564
4 5 2023-05-11T13:35:04+00:00 jhuwwefsr 江玲 xhqwgvhq@hotmail.com 54 525000.0 女 法国 内蒙古自治区嘉兴西湖路167号2单元599 "{""average_price"":565.3900000000001,""category"":""家居"",""items"":[{""id"":963},{""id"":375},{""id"":308}]}" False 2020-11-02 542 276-694-6283
2025-03-31 12:18:43,425 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:18:45,006 - INFO - 数据前几行示例:
2025-03-31 12:18:45,033 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-09T01:38:20+00:00 UZPFPZJ 彭敏 xtnlkqsb@qq.com 36 73000.0 女 俄罗斯 广西壮族自治区绍兴和谐路152号2单元1384 "{""average_price"":15.940000000000001,""category"":""家居"",""items"":[{""id"":631},{""id"":762},{""id"":233},{""id"":535},{""id"":118},{""id"":449},{""id"":256},{""id"":404},{""id"":99},{""id"":638}]}" False 2024-10-02 423 918-668-7857
1 2 2023-07-08T22:53:52+00:00 UEHSG 高杰 rkpktrqz@outlook.com 58 223000.0 女 巴西 黑龙江省大连建设路127号1单元1835 "{""average_price"":563.4100000000001,""category"":""食品"",""items"":[{""id"":425},{""id"":678},{""id"":72},{""id"":666}]}" False 2021-03-19 567 205-503-3300
2 3 2023-12-31T20:00:57+00:00 fxuujvnk 姜子轩 vwnquvla@outlook.com 88 858000.0 男 美国 浙江省厦门繁荣路15号5单元1442 "{""average_price"":669.34,""category"":""书籍"",""items"":[{""id"":395},{""id"":148},{""id"":731},{""id"":847}]}" False 2022-05-07 767 673-105-7503
3 4 2023-03-22T11:12:02+00:00 DDERCI 梁云 jpajekzz@qq.com 61 485000.0 男 德国 四川省宁波上海路30号6单元2134 "{""average_price"":637.66,""category"":""书籍"",""items"":[{""id"":908},{""id"":793},{""id"":121},{""id"":530},{""id"":826},{""id"":395},{""id"":869},{""id"":510},{""id"":506},{""id"":159}]}" False 2020-07-08 587 387-482-7104
4 5 2024-08-10T11:43:08+00:00 RTABMQKQLG 钱俊 haqlhpmb@163.com 33 437000.0 男 中国 四川省成都康乐路181号6单元391 "{""average_price"":505.0,""category"":""家居"",""items"":[{""id"":307},{""id"":439},{""id"":590},{""id"":16},{""id"":393},{""id"":738},{""id"":65},{""id"":519},{""id"":363}]}" False 2023-10-12 404 602-478-3001
2025-03-31 12:18:45,033 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:18:46,815 - INFO - 数据前几行示例:
2025-03-31 12:18:46,843 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-25T07:15:59+00:00 gtlcuz 于宏 ykxyfhgm@163.com 96 746000.0 男 日本 福建省乌鲁木齐东风路80号6单元2277 "{""average_price"":736.66,""category"":""服装"",""items"":[{""id"":295},{""id"":397},{""id"":798},{""id"":906},{""id"":916},{""id"":953},{""id"":855},{""id"":201},{""id"":140},{""id"":302}]}" False 2024-11-09 819 936-365-4573
1 2 2024-10-10T23:32:13+00:00 nbcpsl 马鹏 vfiteszh@hotmail.com 29 944000.0 男 日本 西藏自治区重庆新华路61号6单元662 "{""average_price"":226.81,""category"":""书籍"",""items"":[{""id"":265},{""id"":459},{""id"":817},{""id"":843},{""id"":128}]}" False 2024-03-04 373 924-957-8702
2 3 2025-02-13T22:44:56+00:00 gsbhu 徐雨 yduzrewc@163.com 36 123000.0 女 澳大利亚 江西省长沙青年路163号6单元407 "{""average_price"":596.0799999999999,""category"":""书籍"",""items"":[{""id"":304},{""id"":181},{""id"":895},{""id"":706},{""id"":832},{""id"":972},{""id"":685},{""id"":305}]}" False 2024-12-25 419 371-760-3106
3 4 2023-04-24T03:46:06+00:00 YAAYX 林强 zutmavfa@163.com 58 132000.0 男 美国 安徽省中山振兴路61号2单元2249 "{""average_price"":494.11,""category"":""书籍"",""items"":[{""id"":732},{""id"":126},{""id"":813},{""id"":783},{""id"":36},{""id"":995},{""id"":15},{""id"":661},{""id"":65},{""id"":191}]}" False 2020-09-22 569 463-338-5133
4 5 2023-07-10T07:48:22+00:00 TAJJHCND 廖强 pvyzvahj@outlook.com 57 278000.0 女 巴西 澳门特别行政区南昌西湖路118号7单元377 "{""average_price"":676.2700000000001,""category"":""电子产品"",""items"":[{""id"":327},{""id"":596},{""id"":59},{""id"":997},{""id"":685},{""id"":804},{""id"":185},{""id"":735},{""id"":126},{""id"":489}]}" False 2021-03-23 564 214-297-9938
2025-03-31 12:18:46,843 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:18:48,726 - INFO - 数据前几行示例:
2025-03-31 12:18:48,752 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-09-11T21:05:26+00:00 xwrnixyn 田亮 tefwjoji@hotmail.com 95 625000.0 男 美国 山西省太原学院路37号7单元594 "{""average_price"":306.01,""category"":""食品"",""items"":[{""id"":579},{""id"":186},{""id"":892},{""id"":206},{""id"":503},{""id"":847},{""id"":830},{""id"":347}]}" False 2023-12-27 813 786-620-2670
1 2 2024-12-26T08:26:10+00:00 cztdqb 董欣 kpfuiggp@126.com 24 932000.0 男 美国 广西壮族自治区东莞东风路115号4单元999 "{""average_price"":667.36,""category"":""书籍"",""items"":[{""id"":341}]}" False 2024-08-31 344 552-862-8469
2 3 2024-11-20T00:24:35+00:00 bebtqxuw 潘红 hxusqnzs@outlook.com 78 538000.0 女 英国 云南省中山兴隆路102号3单元210 "{""average_price"":809.9200000000001,""category"":""书籍"",""items"":[{""id"":46},{""id"":598},{""id"":957},{""id"":209},{""id"":335}]}" False 2024-06-06 701 616-533-4370
3 4 2023-09-01T11:43:33+00:00 QZCNRKTUV 孔敏 sstvzrnr@126.com 93 81000.0 男 日本 吉林省宁波兴华路169号3单元2079 "{""average_price"":600.04,""category"":""家居"",""items"":[{""id"":61},{""id"":232},{""id"":925}]}" False 2021-07-26 799 697-896-8597
4 5 2023-11-01T12:00:35+00:00 TSHFYITMO 白军 gwgxobwc@hotmail.com 79 159000.0 女 德国 吉林省乌鲁木齐学院路152号5单元1100 "{""average_price"":517.87,""category"":""家居"",""items"":[{""id"":274},{""id"":975},{""id"":904},{""id"":729},{""id"":781},{""id"":882},{""id"":708},{""id"":864},{""id"":632},{""id"":686}]}" False 2021-12-16 706 141-638-9617
2025-03-31 12:18:48,753 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:18:48,791 - INFO - None
2025-03-31 12:18:49,920 - INFO - id age income credit_score
count 10000000.00 10000000.00 10000000.00 10000000.00
mean 49000.50 59.01 499400.43 575.09
std 28850.19 23.95 289011.11 159.01
min 1.00 18.00 0.00 300.00
25% 24039.00 38.00 249000.00 437.00
50% 48077.00 59.00 499000.00 575.00
75% 73959.00 80.00 750000.00 713.00
max 100000.00 100.00 1000000.00 850.00
2025-03-31 12:18:53,711 - INFO - 数据中不存在缺失值
2025-03-31 12:18:53,736 - INFO - 数据中不存在年龄非法值
2025-03-31 12:19:15,561 - WARNING - 数据中性别列存在异常值，异常值数量: 0
2025-03-31 12:19:15,561 - WARNING - 数据中存在重复行，重复行重复量: 8800000
2025-03-31 12:20:05,955 - INFO - 删除重复行后，数据框中已无重复行。
2025-03-31 12:20:17,750 - INFO - 开始执行 cluster_and_analyze 函数
2025-03-31 12:20:17,750 - INFO - 开始提取 purchase_history 中的 average_price 和 items 的长度
2025-03-31 12:20:24,729 - INFO - 提取完成
2025-03-31 12:20:24,734 - INFO - 选择的特征为: ['income', 'average_price', 'items_count']
2025-03-31 12:20:24,734 - INFO - 开始进行数据标准化
2025-03-31 12:20:24,768 - INFO - 数据标准化完成
2025-03-31 12:20:24,768 - INFO - 最优聚类数 k = 8
2025-03-31 12:20:24,768 - INFO - 开始使用最优聚类数 k = 8 进行 K-means 聚类
2025-03-31 12:20:25,698 - INFO - K-means 聚类完成
2025-03-31 12:20:25,698 - INFO - 开始分析每个聚类的特征
2025-03-31 12:20:25,732 - INFO - 聚类特征分析完成
2025-03-31 12:20:25,732 - INFO - 开始进行 PCA 降维以可视化聚类结果
2025-03-31 12:20:25,772 - INFO - PCA 降维完成
2025-03-31 12:20:25,772 - INFO - 开始绘制散点图可视化聚类结果
2025-03-31 12:20:34,889 - INFO - 将可视化结果保存到 /home/sunminhao/grade8_HOMEWORK/DataMining/Homework1/visualization/cluster_visualization.png
2025-03-31 12:21:25,469 - INFO - 可视化结果保存完成
2025-03-31 12:21:25,469 - INFO - cluster_and_analyze 函数执行结束
2025-03-31 12:21:25,588 - INFO - 每个聚类的特征分析：
2025-03-31 12:21:25,588 - INFO - income average_price items_count
cluster
0 249589.56 257.65 3.00
1 752043.51 753.75 7.99
2 750983.76 257.63 3.01
3 248881.81 257.32 8.00
4 749921.90 752.64 2.99
5 749471.94 257.51 8.00
6 251729.66 751.76 8.00
7 250461.64 752.97 3.01
2025-03-31 12:22:42,300 - INFO - 数据前几行示例:
2025-03-31 12:22:42,302 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-12-20T19:30:36+00:00 xsyxsrvt 廖亮 xxpyxvds@hotmail.com 19 622000.0 男 中国 上海市中山人民路178号3单元1510 "{""average_price"":843.5799999999999,""category"":""电子产品"",""items"":[{""id"":36},{""id"":891},{""id"":420},{""id"":587},{""id"":929},{""id"":940},{""id"":519},{""id"":920},{""id"":621}]}" False 2024-08-18 311 896-131-9026
1 2 2023-12-08T15:55:24+00:00 QILDIW 谢芳 pagkjgxr@hotmail.com 40 20000.0 女 俄罗斯 湖南省乌鲁木齐健康路168号1单元459 "{""average_price"":276.31,""category"":""食品"",""items"":[{""id"":824},{""id"":884},{""id"":732},{""id"":305},{""id"":601},{""id"":754},{""id"":27},{""id"":443}]}" False 2022-03-13 449 936-946-5675
2 3 2025-02-03T20:13:49+00:00 NXMSOJN 蔡秀英 nvdjmyij@gmail.com 60 53000.0 女 澳大利亚 广西壮族自治区中山复兴路61号5单元1912 "{""average_price"":213.94,""category"":""家居"",""items"":[{""id"":793},{""id"":241},{""id"":908},{""id"":887}]}" False 2024-12-01 582 857-179-2343
3 4 2024-05-19T18:33:56+00:00 OKVKJOQA 汪明 dblskeyb@outlook.com 74 271000.0 女 澳大利亚 江苏省石家庄广州路182号3单元2003 "{""average_price"":721.81,""category"":""书籍"",""items"":[{""id"":15},{""id"":522},{""id"":893},{""id"":843},{""id"":156},{""id"":150},{""id"":467},{""id"":378},{""id"":891},{""id"":491}]}" False 2023-03-31 678 841-895-7586
4 5 2023-05-02T09:11:31+00:00 TKZDVTZSN 秦秀英 suskeold@hotmail.com 73 66000.0 男 中国 宁夏回族自治区重庆幸福路117号7单元2367 "{""average_price"":627.76,""category"":""食品"",""items"":[{""id"":348},{""id"":565},{""id"":78},{""id"":792},{""id"":980},{""id"":130},{""id"":977},{""id"":53}]}" False 2020-10-12 671 779-124-4986
2025-03-31 12:22:42,302 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:22:43,586 - INFO - 数据前几行示例:
2025-03-31 12:22:43,612 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-12-30T16:21:57+00:00 fomuwjmlw 江思 lhmqhulm@outlook.com 36 886000.0 女 巴西 青海省合肥广州路57号5单元1213 "{""average_price"":619.84,""category"":""食品"",""items"":[{""id"":411},{""id"":283},{""id"":671},{""id"":464},{""id"":529}]}" False 2022-05-04 424 502-470-3541
1 2 2024-06-29T16:24:59+00:00 FUSAJQR 吕杰 zxundoea@outlook.com 30 226000.0 男 印度 河南省长沙东风路154号3单元1179 "{""average_price"":983.17,""category"":""书籍"",""items"":[{""id"":428},{""id"":449},{""id"":225},{""id"":490},{""id"":220},{""id"":732},{""id"":593},{""id"":108}]}" False 2023-07-05 379 575-654-5232
2 3 2024-05-15T21:10:05+00:00 gvzzkmrc 田嘉 khkwgijh@outlook.com 92 807000.0 女 英国 吉林省金华学院路22号7单元2057 "{""average_price"":750.52,""category"":""电子产品"",""items"":[{""id"":692},{""id"":514},{""id"":852},{""id"":144},{""id"":923},{""id"":561},{""id"":434},{""id"":155}]}" False 2023-03-22 795 793-485-5044
3 4 2023-08-22T16:09:22+00:00 UESELUB 叶磊 wqnjvdue@outlook.com 35 145000.0 男 印度 台湾省南昌工业路170号2单元2317 "{""average_price"":923.7700000000001,""category"":""书籍"",""items"":[{""id"":361},{""id"":410},{""id"":327},{""id"":306},{""id"":782},{""id"":395}]}" False 2021-07-02 414 297-758-6341
4 5 2024-01-01T07:48:21+00:00 GQSUBU 马磊 ddajkaog@163.com 25 136000.0 男 德国 山西省徐州人民路36号6单元1374 "{""average_price"":220.87,""category"":""家居"",""items"":[{""id"":332},{""id"":689},{""id"":371},{""id"":175},{""id"":297},{""id"":599},{""id"":680}]}" False 2022-05-08 351 833-918-3483
2025-03-31 12:22:43,612 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:22:44,916 - INFO - 数据前几行示例:
2025-03-31 12:22:44,941 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-03-22T05:14:02+00:00 ladgtp 唐玲 otdekffb@hotmail.com 61 524000.0 其他 澳大利亚 澳门特别行政区温州新华路148号3单元438 "{""average_price"":921.7900000000001,""category"":""服装"",""items"":[{""id"":134},{""id"":741},{""id"":423},{""id"":141},{""id"":928},{""id"":174}]}" False 2022-11-14 589 593-219-7670
1 2 2023-12-10T11:59:48+00:00 ydbpkymj 潘玲 nisgdysd@hotmail.com 45 526000.0 女 巴西 新疆维吾尔自治区昆明中山路43号1单元634 "{""average_price"":576.28,""category"":""电子产品"",""items"":[{""id"":223}]}" False 2022-03-17 481 935-256-9289
2 3 2023-05-22T08:56:07+00:00 akudv 林宏 wireteca@163.com 20 904000.0 女 澳大利亚 陕西省兰州文化路42号4单元550 "{""average_price"":705.9699999999999,""category"":""电子产品"",""items"":[{""id"":209},{""id"":525},{""id"":188},{""id"":339},{""id"":290}]}" False 2020-11-28 315 290-109-3000
3 4 2023-01-12T16:03:41+00:00 QNQFFFSRS 邱霞 alfsyuaw@qq.com 39 330000.0 男 日本 陕西省杭州友谊路14号1单元1609 "{""average_price"":275.32,""category"":""家居"",""items"":[{""id"":628},{""id"":939}]}" False 2020-01-28 440 709-976-5486
4 5 2023-06-30T17:26:53+00:00 JGAKPKYAT 秦波 ujlxnjww@gmail.com 96 430000.0 男 中国 甘肃省烟台胜利路69号7单元155 "{""average_price"":893.08,""category"":""服装"",""items"":[{""id"":954},{""id"":23},{""id"":493},{""id"":873}]}" False 2021-02-28 820 268-404-3607
2025-03-31 12:22:44,941 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:22:46,331 - INFO - 数据前几行示例:
2025-03-31 12:22:46,356 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-15T02:06:51+00:00 DFPYPK 冯娜 xlbvwqnk@126.com 77 36000.0 女 巴西 青海省绍兴青年路90号1单元241 "{""average_price"":361.45,""category"":""食品"",""items"":[{""id"":466},{""id"":448},{""id"":6},{""id"":59},{""id"":302},{""id"":845},{""id"":386},{""id"":846},{""id"":337},{""id"":617}]}" False 2024-10-16 693 924-519-5030
1 2 2023-01-05T14:43:16+00:00 wzobou 马晓 pqkfyphb@gmail.com 96 714000.0 男 德国 江西省保定北京路123号3单元1336 "{""average_price"":406.99,""category"":""家居"",""items"":[{""id"":542},{""id"":952},{""id"":759},{""id"":615},{""id"":968},{""id"":650},{""id"":459}]}" False 2020-01-11 823 371-860-4475
2 3 2024-11-17T23:59:54+00:00 ftotzea 傅佳 deihadwa@outlook.com 30 841000.0 男 日本 四川省温州平安路152号5单元2424 "{""average_price"":152.56,""category"":""服装"",""items"":[{""id"":233},{""id"":595},{""id"":704},{""id"":279},{""id"":690},{""id"":42},{""id"":752},{""id"":153},{""id"":285},{""id"":716}]}" False 2024-06-01 381 655-419-5633
3 4 2023-10-01T16:58:51+00:00 wwsbbu 马雨 diwflftg@gmail.com 53 950000.0 女 俄罗斯 江西省南通长江路97号7单元659 "{""average_price"":712.9,""category"":""电子产品"",""items"":[{""id"":131},{""id"":281},{""id"":207},{""id"":22}]}" False 2021-10-05 532 644-588-9573
4 5 2024-02-23T13:10:07+00:00 wtbca 杨玲 bxuurmyu@163.com 88 522000.0 男 日本 江苏省南昌人民路150号2单元784 "{""average_price"":489.15999999999997,""category"":""家居"",""items"":[{""id"":37}]}" False 2022-09-10 769 971-685-5134
2025-03-31 12:22:46,356 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:22:47,880 - INFO - 数据前几行示例:
2025-03-31 12:22:47,912 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2023-07-18T20:47:01+00:00 hcvomsn 阎欣怡 gdbepeeo@qq.com 96 957000.0 女 俄罗斯 广西壮族自治区郑州西湖路30号2单元255 "{""average_price"":73.36,""category"":""服装"",""items"":[{""id"":310},{""id"":149},{""id"":218}]}" False 2021-04-12 822 320-378-2335
1 2 2023-06-27T08:01:35+00:00 qzzqwskj 汪雨 krxwzgui@163.com 83 948000.0 男 美国 台湾省石家庄广州路38号5单元486 "{""average_price"":412.92999999999995,""category"":""服装"",""items"":[{""id"":401},{""id"":191},{""id"":669},{""id"":161},{""id"":116},{""id"":556}]}" False 2021-02-20 736 357-247-8081
2 3 2023-05-14T07:03:05+00:00 MOMJKHJ 蔡娜 zislhnwf@hotmail.com 58 34000.0 男 印度 江西省昆明上海路172号3单元571 "{""average_price"":879.22,""category"":""食品"",""items"":[{""id"":196},{""id"":660},{""id"":587},{""id"":917},{""id"":369}]}" False 2020-11-09 569 271-702-2445
3 4 2023-11-23T05:24:11+00:00 gdpwmam 彭涵 ngjrhsvl@163.com 36 793000.0 女 英国 新疆维吾尔自治区无锡安宁路87号7单元446 "{""average_price"":327.79,""category"":""书籍"",""items"":[{""id"":893},{""id"":807},{""id"":786}]}" False 2022-02-05 424 466-458-4564
4 5 2023-05-11T13:35:04+00:00 jhuwwefsr 江玲 xhqwgvhq@hotmail.com 54 525000.0 女 法国 内蒙古自治区嘉兴西湖路167号2单元599 "{""average_price"":565.3900000000001,""category"":""家居"",""items"":[{""id"":963},{""id"":375},{""id"":308}]}" False 2020-11-02 542 276-694-6283
2025-03-31 12:22:47,912 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:22:49,675 - INFO - 数据前几行示例:
2025-03-31 12:22:49,710 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-09T01:38:20+00:00 UZPFPZJ 彭敏 xtnlkqsb@qq.com 36 73000.0 女 俄罗斯 广西壮族自治区绍兴和谐路152号2单元1384 "{""average_price"":15.940000000000001,""category"":""家居"",""items"":[{""id"":631},{""id"":762},{""id"":233},{""id"":535},{""id"":118},{""id"":449},{""id"":256},{""id"":404},{""id"":99},{""id"":638}]}" False 2024-10-02 423 918-668-7857
1 2 2023-07-08T22:53:52+00:00 UEHSG 高杰 rkpktrqz@outlook.com 58 223000.0 女 巴西 黑龙江省大连建设路127号1单元1835 "{""average_price"":563.4100000000001,""category"":""食品"",""items"":[{""id"":425},{""id"":678},{""id"":72},{""id"":666}]}" False 2021-03-19 567 205-503-3300
2 3 2023-12-31T20:00:57+00:00 fxuujvnk 姜子轩 vwnquvla@outlook.com 88 858000.0 男 美国 浙江省厦门繁荣路15号5单元1442 "{""average_price"":669.34,""category"":""书籍"",""items"":[{""id"":395},{""id"":148},{""id"":731},{""id"":847}]}" False 2022-05-07 767 673-105-7503
3 4 2023-03-22T11:12:02+00:00 DDERCI 梁云 jpajekzz@qq.com 61 485000.0 男 德国 四川省宁波上海路30号6单元2134 "{""average_price"":637.66,""category"":""书籍"",""items"":[{""id"":908},{""id"":793},{""id"":121},{""id"":530},{""id"":826},{""id"":395},{""id"":869},{""id"":510},{""id"":506},{""id"":159}]}" False 2020-07-08 587 387-482-7104
4 5 2024-08-10T11:43:08+00:00 RTABMQKQLG 钱俊 haqlhpmb@163.com 33 437000.0 男 中国 四川省成都康乐路181号6单元391 "{""average_price"":505.0,""category"":""家居"",""items"":[{""id"":307},{""id"":439},{""id"":590},{""id"":16},{""id"":393},{""id"":738},{""id"":65},{""id"":519},{""id"":363}]}" False 2023-10-12 404 602-478-3001
2025-03-31 12:22:49,710 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:22:51,767 - INFO - 数据前几行示例:
2025-03-31 12:22:51,797 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2025-01-25T07:15:59+00:00 gtlcuz 于宏 ykxyfhgm@163.com 96 746000.0 男 日本 福建省乌鲁木齐东风路80号6单元2277 "{""average_price"":736.66,""category"":""服装"",""items"":[{""id"":295},{""id"":397},{""id"":798},{""id"":906},{""id"":916},{""id"":953},{""id"":855},{""id"":201},{""id"":140},{""id"":302}]}" False 2024-11-09 819 936-365-4573
1 2 2024-10-10T23:32:13+00:00 nbcpsl 马鹏 vfiteszh@hotmail.com 29 944000.0 男 日本 西藏自治区重庆新华路61号6单元662 "{""average_price"":226.81,""category"":""书籍"",""items"":[{""id"":265},{""id"":459},{""id"":817},{""id"":843},{""id"":128}]}" False 2024-03-04 373 924-957-8702
2 3 2025-02-13T22:44:56+00:00 gsbhu 徐雨 yduzrewc@163.com 36 123000.0 女 澳大利亚 江西省长沙青年路163号6单元407 "{""average_price"":596.0799999999999,""category"":""书籍"",""items"":[{""id"":304},{""id"":181},{""id"":895},{""id"":706},{""id"":832},{""id"":972},{""id"":685},{""id"":305}]}" False 2024-12-25 419 371-760-3106
3 4 2023-04-24T03:46:06+00:00 YAAYX 林强 zutmavfa@163.com 58 132000.0 男 美国 安徽省中山振兴路61号2单元2249 "{""average_price"":494.11,""category"":""书籍"",""items"":[{""id"":732},{""id"":126},{""id"":813},{""id"":783},{""id"":36},{""id"":995},{""id"":15},{""id"":661},{""id"":65},{""id"":191}]}" False 2020-09-22 569 463-338-5133
4 5 2023-07-10T07:48:22+00:00 TAJJHCND 廖强 pvyzvahj@outlook.com 57 278000.0 女 巴西 澳门特别行政区南昌西湖路118号7单元377 "{""average_price"":676.2700000000001,""category"":""电子产品"",""items"":[{""id"":327},{""id"":596},{""id"":59},{""id"":997},{""id"":685},{""id"":804},{""id"":185},{""id"":735},{""id"":126},{""id"":489}]}" False 2021-03-23 564 214-297-9938
2025-03-31 12:22:51,797 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:22:54,130 - INFO - 数据前几行示例:
2025-03-31 12:22:54,172 - INFO - id timestamp user_name chinese_name email age income gender country chinese_address purchase_history is_active registration_date credit_score phone_number
0 1 2024-09-11T21:05:26+00:00 xwrnixyn 田亮 tefwjoji@hotmail.com 95 625000.0 男 美国 山西省太原学院路37号7单元594 "{""average_price"":306.01,""category"":""食品"",""items"":[{""id"":579},{""id"":186},{""id"":892},{""id"":206},{""id"":503},{""id"":847},{""id"":830},{""id"":347}]}" False 2023-12-27 813 786-620-2670
1 2 2024-12-26T08:26:10+00:00 cztdqb 董欣 kpfuiggp@126.com 24 932000.0 男 美国 广西壮族自治区东莞东风路115号4单元999 "{""average_price"":667.36,""category"":""书籍"",""items"":[{""id"":341}]}" False 2024-08-31 344 552-862-8469
2 3 2024-11-20T00:24:35+00:00 bebtqxuw 潘红 hxusqnzs@outlook.com 78 538000.0 女 英国 云南省中山兴隆路102号3单元210 "{""average_price"":809.9200000000001,""category"":""书籍"",""items"":[{""id"":46},{""id"":598},{""id"":957},{""id"":209},{""id"":335}]}" False 2024-06-06 701 616-533-4370
3 4 2023-09-01T11:43:33+00:00 QZCNRKTUV 孔敏 sstvzrnr@126.com 93 81000.0 男 日本 吉林省宁波兴华路169号3单元2079 "{""average_price"":600.04,""category"":""家居"",""items"":[{""id"":61},{""id"":232},{""id"":925}]}" False 2021-07-26 799 697-896-8597
4 5 2023-11-01T12:00:35+00:00 TSHFYITMO 白军 gwgxobwc@hotmail.com 79 159000.0 女 德国 吉林省乌鲁木齐学院路152号5单元1100 "{""average_price"":517.87,""category"":""家居"",""items"":[{""id"":274},{""id"":975},{""id"":904},{""id"":729},{""id"":781},{""id"":882},{""id"":708},{""id"":864},{""id"":632},{""id"":686}]}" False 2021-12-16 706 141-638-9617
2025-03-31 12:22:54,172 - INFO - --------------------------------------------------------------------------------
2025-03-31 12:22:54,236 - INFO - None
2025-03-31 12:22:55,325 - INFO - id age income credit_score
count 10000000.00 10000000.00 10000000.00 10000000.00
mean 49000.50 59.01 499400.43 575.09
std 28850.19 23.95 289011.11 159.01
min 1.00 18.00 0.00 300.00
25% 24039.00 38.00 249000.00 437.00
50% 48077.00 59.00 499000.00 575.00
75% 73959.00 80.00 750000.00 713.00
max 100000.00 100.00 1000000.00 850.00
2025-03-31 12:22:59,334 - INFO - 数据中不存在缺失值
2025-03-31 12:22:59,356 - INFO - 数据中不存在年龄非法值
2025-03-31 12:23:19,081 - WARNING - 数据中性别列存在异常值，异常值数量: 0