2021-08-22

最新推荐文章于 2021-11-09 20:10:55 发布
最新推荐文章于 2021-11-09 20:10:55 发布
阅读量116 收藏
点赞数
文章标签： python
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_43134594/article/details/119852430
版权

/home/panda/miniconda3/envs/py37/bin/python /home/panda/Desktop/PythonProject/spert-master-xu/spert.py train --config configs/example_train.conf

Config:
{‘label’: ‘conll04_train’, ‘model_type’: ‘spert’, ‘model_path’: ‘bert-base-cased/pytorch-model.bin’, ‘tokenizer_path’: ‘bert-base-cased/bert-base-vocab.txt’, ‘config_path’: ‘bert-base-cased/bert_config.json’, ‘train_path’: ‘data/conll04/conll04_train.json’, ‘valid_path’: ‘data/conll04/conll04_dev.json’, ‘types_path’: ‘data/conll04/conll04_types.json’, ‘train_batch_size’: ‘2’, ‘eval_batch_size’: ‘1’, ‘neg_entity_count’: ‘100’, ‘neg_relation_count’: ‘100’, ‘epochs’: ‘300’, ‘lr’: ‘5e-5’, ‘lr_warmup’: ‘0.1’, ‘weight_decay’: ‘0.01’, ‘max_grad_norm’: ‘1.0’, ‘rel_filter_threshold’: ‘0.4’, ‘size_embedding’: ‘50’, ‘prop_drop’: ‘0.3’, ‘max_span_size’: ‘10’, ‘store_predictions’: ‘true’, ‘store_examples’: ‘true’, ‘sampling_processes’: ‘4’, ‘sampling_limit’: ‘100’, ‘max_pairs’: ‘1000’, ‘final_eval’: ‘true’, ‘log_path’: ‘data/log’, ‘save_path’: ‘data/model’}
Repeat 1 times

Iteration 0

Calling BertTokenizer.from_pretrained() with the path to a single file or url is deprecated
2021-08-22 06:09:05,562 [MainThread ] [INFO ] Datasets: data/conll04/conll04_train.json, data/conll04/conll04_dev.json
2021-08-22 06:09:05,562 [MainThread ] [INFO ] Model type: spert
Parse dataset ‘train’: 100%|██████████| 922/922 [00:01<00:00, 524.62it/s]
Parse dataset ‘valid’: 100%|██████████| 231/231 [00:00<00:00, 482.52it/s]
2021-08-22 06:09:07,813 [MainThread ] [INFO ] Relation type count: 6
2021-08-22 06:09:07,813 [MainThread ] [INFO ] Entity type count: 5
2021-08-22 06:09:07,813 [MainThread ] [INFO ] Entities:
2021-08-22 06:09:07,813 [MainThread ] [INFO ] No Entity=0
2021-08-22 06:09:07,813 [MainThread ] [INFO ] Location=1
2021-08-22 06:09:07,813 [MainThread ] [INFO ] Organization=2
2021-08-22 06:09:07,814 [MainThread ] [INFO ] People=3
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Other=4
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Relations:
2021-08-22 06:09:07,814 [MainThread ] [INFO ] No Relation=0
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Work for=1
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Kill=2
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Organization based in=3
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Live in=4
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Located in=5
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Dataset: train
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Document count: 922
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Relation count: 1283
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Entity count: 3377
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Dataset: valid
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Document count: 231
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Relation count: 343
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Entity count: 893
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Context size: 150
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Updates per epoch: 461
2021-08-22 06:09:07,814 [MainThread ] [INFO ] Updates total: 138300
Some weights of the model checkpoint at bert-base-cased/pytorch-model.bin were not used when initializing SpERT: [‘cls.predictions.bias’, ‘cls.predictions.transform.dense.weight’, ‘cls.predictions.transform.dense.bias’, ‘cls.predictions.decoder.weight’, ‘cls.seq_relationship.weight’, ‘cls.seq_relationship.bias’, ‘cls.predictions.transform.LayerNorm.weight’, ‘cls.predictions.transform.LayerNorm.bias’]

  • This IS expected if you are initializing SpERT from the checkpoint of a model trained on another task or with another architecture (e.g. initializing a BertForSequenceClassification model from a BertForPreTraining model).
  • This IS NOT expected if you are initializing SpERT from the checkpoint of a model that you expect to be exactly identical (initializing a BertForSequenceClassification model from a BertForSequenceClassification model).
    Some weights of SpERT were not initialized from the model checkpoint at bert-base-cased/pytorch-model.bin and are newly initialized: [‘rel_classifier.weight’, ‘rel_classifier.bias’, ‘entity_classifier.weight’, ‘entity_classifier.bias’, ‘size_embeddings.weight’, ‘W0.weight’, ‘W0.bias’, ‘W1.weight’, ‘W1.bias’, ‘W2.weight’, ‘W2.bias’, ‘W3.weight’, ‘W3.bias’, ‘W4.weight’, ‘W4.bias’, ‘W5.weight’, ‘W5.bias’, ‘W6.weight’, ‘W6.bias’, ‘W7.weight’, ‘W7.bias’, ‘W_gmlp.weight’, ‘W_gmlp.bias’, ‘mlp_encoder.weight’, ‘mlp_encoder.bias’, ‘multi_att.linear_q.weight’, ‘multi_att.linear_k.weight’, ‘multi_att.linear_v.weight’]
    You should probably TRAIN this model on a down-stream task to be able to use it for predictions and inference.
    Train epoch 0: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 06:09:12,299 [MainThread ] [INFO ] Train epoch: 0
    Train epoch 0: 100%|██████████| 461/461 [03:05<00:00, 2.49it/s]
    Evaluate epoch 1: 0%| | 0/231 [00:00<?, ?it/s]2021-08-22 06:12:17,761 [MainThread ] [INFO ] Evaluate: valid
    Evaluate epoch 1: 100%|██████████| 231/231 [01:07<00:00, 3.41it/s]
    Evaluation

— Entities (named entity recognition (NER)) —
An entity is considered correct if the entity type and span is predicted correctly

            type    precision       recall     f1-score      support
             Org         0.00         0.00         0.00        170.0
           Other         0.00         0.00         0.00        118.0
            Peop         0.00         0.00         0.00        283.0
             Loc         0.00         0.00         0.00        322.0

           micro         0.00         0.00         0.00        893.0
           macro         0.00         0.00         0.00        893.0

— Relations —

Without named entity classification (NEC)
A relation is considered correct if the relation type and the spans of the two related entities are predicted correctly (entity type is not considered)

            type    precision       recall     f1-score      support
           LocIn         0.00         0.00         0.00         65.0
            Live         0.00         0.00         0.00         91.0
            Work         0.00         0.00         0.00         69.0
           OrgBI         0.00         0.00         0.00         76.0
            Kill         0.00         0.00         0.00         42.0

           micro         0.00         0.00         0.00        343.0
           macro         0.00         0.00         0.00        343.0

With named entity classification (NEC)
A relation is considered correct if the relation type and the two related entities are predicted correctly (in span and entity type)

            type    precision       recall     f1-score      support
           LocIn         0.00         0.00         0.00         65.0
            Live         0.00         0.00         0.00         91.0
            Work         0.00         0.00         0.00         69.0
           OrgBI         0.00         0.00         0.00         76.0
            Kill         0.00         0.00         0.00         42.0

           micro         0.00         0.00         0.00        343.0
           macro         0.00         0.00         0.00        343.0

2021-08-22 06:13:26,743 [MainThread ] [INFO ] Train epoch: 1
Train epoch 1: 100%|██████████| 461/461 [03:07<00:00, 2.46it/s]
2021-08-22 06:16:33,955 [MainThread ] [INFO ] Train epoch: 2
Train epoch 2: 100%|██████████| 461/461 [03:11<00:00, 2.41it/s]
Train epoch 3: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 06:19:45,415 [MainThread ] [INFO ] Train epoch: 3
Train epoch 3: 100%|██████████| 461/461 [03:13<00:00, 2.38it/s]
Train epoch 4: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 06:22:58,997 [MainThread ] [INFO ] Train epoch: 4
Train epoch 4: 100%|██████████| 461/461 [03:05<00:00, 2.48it/s]
2021-08-22 06:26:04,921 [MainThread ] [INFO ] Train epoch: 5
Train epoch 5: 100%|██████████| 461/461 [03:07<00:00, 2.45it/s]
Train epoch 6: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 06:29:12,767 [MainThread ] [INFO ] Train epoch: 6
Train epoch 6: 100%|██████████| 461/461 [03:15<00:00, 2.36it/s]
Train epoch 7: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 06:32:27,822 [MainThread ] [INFO ] Train epoch: 7
Train epoch 7: 100%|██████████| 461/461 [03:08<00:00, 2.44it/s]
2021-08-22 06:35:36,429 [MainThread ] [INFO ] Train epoch: 8
Train epoch 8: 100%|██████████| 461/461 [03:14<00:00, 2.38it/s]
Train epoch 9: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 06:38:50,479 [MainThread ] [INFO ] Train epoch: 9
Train epoch 9: 100%|██████████| 461/461 [03:08<00:00, 2.44it/s]
Train epoch 10: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 06:41:59,257 [MainThread ] [INFO ] Train epoch: 10
Train epoch 10: 100%|██████████| 461/461 [03:11<00:00, 2.41it/s]
2021-08-22 06:45:10,902 [MainThread ] [INFO ] Train epoch: 11
Train epoch 11: 100%|██████████| 461/461 [03:13<00:00, 2.39it/s]
Train epoch 12: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 06:48:24,077 [MainThread ] [INFO ] Train epoch: 12
Train epoch 12: 100%|██████████| 461/461 [03:15<00:00, 2.36it/s]
Train epoch 13: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 06:51:39,384 [MainThread ] [INFO ] Train epoch: 13
Train epoch 13: 100%|██████████| 461/461 [03:18<00:00, 2.32it/s]
Train epoch 14: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 06:54:58,072 [MainThread ] [INFO ] Train epoch: 14
Train epoch 14: 100%|██████████| 461/461 [03:11<00:00, 2.40it/s]
2021-08-22 06:58:10,049 [MainThread ] [INFO ] Train epoch: 15
Train epoch 15: 100%|██████████| 461/461 [03:14<00:00, 2.38it/s]
2021-08-22 07:01:24,127 [MainThread ] [INFO ] Train epoch: 16
Train epoch 16: 100%|██████████| 461/461 [03:17<00:00, 2.33it/s]
Train epoch 17: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:04:41,951 [MainThread ] [INFO ] Train epoch: 17
Train epoch 17: 100%|██████████| 461/461 [03:13<00:00, 2.39it/s]
Train epoch 18: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:07:55,191 [MainThread ] [INFO ] Train epoch: 18
Train epoch 18: 100%|██████████| 461/461 [03:16<00:00, 2.34it/s]
Train epoch 19: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:11:12,065 [MainThread ] [INFO ] Train epoch: 19
Train epoch 19: 100%|██████████| 461/461 [03:08<00:00, 2.44it/s]
Train epoch 20: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:14:20,983 [MainThread ] [INFO ] Train epoch: 20
Train epoch 20: 100%|██████████| 461/461 [03:18<00:00, 2.32it/s]
2021-08-22 07:17:39,297 [MainThread ] [INFO ] Evaluate: valid
Evaluate epoch 21: 100%|██████████| 231/231 [01:08<00:00, 3.37it/s]
Evaluation

— Entities (named entity recognition (NER)) —
An entity is considered correct if the entity type and span is predicted correctly

            type    precision       recall     f1-score      support
             Org        48.64        73.53        58.55          170
           Other        57.94        61.86        59.84          118
            Peop        81.79        90.46        85.91          283
             Loc        61.49        92.24        73.79          322

           micro        63.70        84.10        72.49          893
           macro        62.46        79.52        69.52          893

— Relations —

Without named entity classification (NEC)
A relation is considered correct if the relation type and the spans of the two related entities are predicted correctly (entity type is not considered)

            type    precision       recall     f1-score      support
           LocIn        29.31        78.46        42.68           65
            Live        25.87        81.32        39.26           91
            Work        22.91        75.36        35.14           69
           OrgBI        17.42        40.79        24.41           76
            Kill        59.18        69.05        63.74           42

           micro        25.93        69.10        37.71          343
           macro        30.94        69.00        41.04          343

With named entity classification (NEC)
A relation is considered correct if the relation type and the two related entities are predicted correctly (in span and entity type)

            type    precision       recall     f1-score      support
           LocIn        29.31        78.46        42.68           65
            Live        25.87        81.32        39.26           91
            Work        22.47        73.91        34.46           69
           OrgBI        17.42        40.79        24.41           76
            Kill        59.18        69.05        63.74           42

           micro        25.82        68.80        37.55          343
           macro        30.85        68.71        40.91          343

2021-08-22 07:18:49,313 [MainThread ] [INFO ] Train epoch: 21
Train epoch 21: 100%|██████████| 461/461 [03:11<00:00, 2.41it/s]
Train epoch 22: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:22:00,689 [MainThread ] [INFO ] Train epoch: 22
Train epoch 22: 100%|██████████| 461/461 [03:18<00:00, 2.32it/s]
2021-08-22 07:25:19,599 [MainThread ] [INFO ] Train epoch: 23
Train epoch 23: 100%|██████████| 461/461 [03:17<00:00, 2.34it/s]
Train epoch 24: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:28:36,735 [MainThread ] [INFO ] Train epoch: 24
Train epoch 24: 100%|██████████| 461/461 [03:07<00:00, 2.45it/s]
Train epoch 25: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:31:44,691 [MainThread ] [INFO ] Train epoch: 25
Train epoch 25: 100%|██████████| 461/461 [03:11<00:00, 2.41it/s]
Train epoch 26: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:34:56,338 [MainThread ] [INFO ] Train epoch: 26
Train epoch 26: 100%|██████████| 461/461 [03:12<00:00, 2.39it/s]
2021-08-22 07:38:09,090 [MainThread ] [INFO ] Train epoch: 27
Train epoch 27: 100%|██████████| 461/461 [03:13<00:00, 2.38it/s]
Train epoch 28: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:41:22,404 [MainThread ] [INFO ] Train epoch: 28
Train epoch 28: 100%|██████████| 461/461 [03:11<00:00, 2.40it/s]
Train epoch 29: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:44:34,378 [MainThread ] [INFO ] Train epoch: 29
Train epoch 29: 100%|██████████| 461/461 [03:12<00:00, 2.39it/s]
2021-08-22 07:47:47,195 [MainThread ] [INFO ] Train epoch: 30
Train epoch 30: 100%|██████████| 461/461 [03:09<00:00, 2.44it/s]
Train epoch 31: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:50:56,509 [MainThread ] [INFO ] Train epoch: 31
Train epoch 31: 100%|██████████| 461/461 [03:16<00:00, 2.34it/s]
2021-08-22 07:54:13,479 [MainThread ] [INFO ] Train epoch: 32
Train epoch 32: 100%|██████████| 461/461 [03:17<00:00, 2.33it/s]
Train epoch 33: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 07:57:31,343 [MainThread ] [INFO ] Train epoch: 33
Train epoch 33: 100%|██████████| 461/461 [03:19<00:00, 2.31it/s]
Train epoch 34: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 08:00:51,162 [MainThread ] [INFO ] Train epoch: 34
Train epoch 34: 100%|██████████| 461/461 [03:08<00:00, 2.44it/s]
Train epoch 35: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 08:04:00,137 [MainThread ] [INFO ] Train epoch: 35
Train epoch 35: 100%|██████████| 461/461 [03:15<00:00, 2.36it/s]
Train epoch 36: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 08:07:15,188 [MainThread ] [INFO ] Train epoch: 36
Train epoch 36: 100%|██████████| 461/461 [03:09<00:00, 2.43it/s]
Train epoch 37: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 08:10:24,540 [MainThread ] [INFO ] Train epoch: 37
Train epoch 37: 100%|██████████| 461/461 [03:13<00:00, 2.38it/s]
Train epoch 38: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 08:13:38,159 [MainThread ] [INFO ] Train epoch: 38
Train epoch 38: 100%|██████████| 461/461 [03:13<00:00, 2.38it/s]
Train epoch 39: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 08:16:51,570 [MainThread ] [INFO ] Train epoch: 39
Train epoch 39: 100%|██████████| 461/461 [03:17<00:00, 2.34it/s]
Train epoch 40: 0%| | 0/461 [00:00<?, ?it/s]2021-08-22 08:20:08,715 [MainThread ] [INFO ] Train epoch: 40
Train epoch 40: 100%|██████████| 461/461 [03:13<00:00, 2.38it/s]
Evaluate epoch 41: 0%| | 0/231 [00:00<?, ?it/s]2021-08-22 08:23:22,695 [MainThread ] [INFO ] Evaluate: valid
Evaluate epoch 41: 100%|██████████| 231/231 [01:07<00:00, 3.42it/s]
Evaluation

— Entities (named entity recognition (NER)) —
An entity is considered correct if the entity type and span is predicted correctly

            type    precision       recall     f1-score      support
             Org        67.74        61.76        64.62          170
           Other        66.02        57.63        61.54          118
            Peop        86.82        90.81        88.77          283
             Loc        78.83        87.89        83.11          322

           micro        78.09        79.84        78.96          893
           macro        74.85        74.52        74.51          893

— Relations —

Without named entity classification (NEC)
A relation is considered correct if the relation type and the spans of the two related entities are predicted correct

最低0.47元/天 解锁文章
流水love人家
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
SpERT源码阅读 #on-working#
qq_39540454的博客
05-21 1157
项目重要文件的目录树如下： spert │ args.py # 各种参数的设置 │ config_reader.py # 读取并处理config文件 │ spert.py # 程序入口 │ __init__.py # 空文件，用于构成package ├─bert-base-chinese │ bert_config.json │ config.json │ pytorch_model.bin │ vocab.
python turtle代码示例-Python turtle.left方法代码示例
weixin_39673184的博客
11-11 2658
本文整理汇总了Python中turtle.left方法的典型用法代码示例。如果您正苦于以下问题：Python turtle.left方法的具体用法？Python turtle.left怎么用？Python turtle.left使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在模块turtle的用法示例。在下文中一共展示了turtle.left方法的...
2021-04-21
qq_56102648的博客
04-21 749
2021-08-30
m0_52741263的博客
09-06 3317
Python期末复习 常见函数 重点题型 一、切片索引 ①若x=[1,2,3,4]，那么执行x[:]=5后，x的值是[5]。（F） #执行程序 x=[1,2,3,4] print(x[:]) #输出结果 [1,2,3,4] ②列表lst=[12, -5, -22, -10, -26, 35, 0, 49, 3, -21],lst[::]的结果是[12, -5, -22, -10, -26, 35, 0, 49, 3, -21]。 （T） #执行程序 list=[12, -5, -22, -10
2021-01-04
wubaoyu123的博客
01-04 2173
博客园Logo 首页 新闻 博问 专区 闪存 班级 代码改变世界 搜索 注册 登录 返回主页 知了一笑 博客园 首页 新随笔 联系 订阅 管理 数据仓库组件：Hive环境搭建和基础用法 本文源码：GitHub || GitEE 一、Hive基础简介 1、基础描述 Hive是基于Hadoop的一个数据仓库工具，用来进行数据提取、转化、加载，是一个可以对Hadoop中的大规模存储的数据进行查询和分析存储的组件，Hive数据仓库工具能将结构化的数据文件映射为一张数据库表，并提供SQL查询功能，能将SQL语句转变成
2021-08-13
m0_57784122的博客
08-13 9439
txvideo://v.qq.com/VideoDetailActivity?redirect=1&redirectChannelId=120121&vid=o3266zxbyrc&from=20595&logsour=2030150265&ext=%7B%22feedid%22%3A%22%22%2C%22chid%22%3A207009206%2C%22num%22%3A1%2C%22position%22%3A%22%22%2C%22testid%22%3A%2
2021-01-10
qq_22667507的博客
01-10 903
jupyter notebook中直接安装python的第三方库。 例如安装pymysql ： ! pip install pymysql。 升级pip：
2021-06-08
热门推荐
luquanyou的博客
11-09 2万+
Copyright © 2017-2020, googlehosts members. https://github.com/googlehosts/hosts Last updated: 2020-02-19 This work is licensed under a modified HOSTS License. https://github.com/googlehosts/hosts/raw/master/LICENSE Modified Hosts Start Localhost (DO NOT R
2021-05-05
樊金良的博客
05-05 650
你需要努力，fighting！
2021-01-15
hikarilee的博客
01-15 1195
git clone 操作出现 fatal:index-pack failed 此错误为当前克隆文件夹属性只读，将只读取消
NBA 2021-2022 赛季 阵容（2021.08.22）B.pdf
08-22
NBA 2021-2022 赛季 阵容（2021.08.22）B.pdf
扫描全能王 2021-12-08 22.docx
12-08
扫描全能王 2021-12-08 22.docx
扫描全能王 2021-08-15 22.04.pdf
08-15
扫描全能王 2021-08-15 22.04.pdf
NOIP2008提高组初赛试题-C++含答案---改动(2021.08.20).pdf
08-20
7. 将十进制数28.5625转换为四进制，得到130.22。 8. 归过程或函数调用时，处理参数和返回地址通常使用栈这种数据结构。 9. TCP/IP协议的网络层提供源节点和目的节点之间的信息传输服务，包括寻址和路由器选择等功能...
class_narwhal：2021-01-25全栈Python Day班
02-13
实验09-单位转换器实验10-平均数实验15-短语编号实验19-二十一点实验14-选择6 实验20-信用卡验证实验13-ROT13 组-Jackalope 实验18-峰谷实验22-ARI 实验21-数词 可选的Python实验室 练习1-5 实验01-08、11、12、17...
2021-M5Bioinfo:M5课程中“统计和机器学习”模块的材料
05-06
2021-02-08星期一：监督学习。 以及2021-02-12星期五：可视化图形。 以及。 （ ）。 2021-02-15星期一：（多次）测试。 以及2021-02-19星期五：计数数据和广义线性模型。 以及如何使用本材料：如果您想确定优先级，...
site-status：站点状态
02-25
2021-08-22 2021-05-27 2021-08-22 2021-08-22 剩余领域天数 250 179 92 179 179 证书续订日期 -- -- 2021-02-01 2021-02-01 2021-02-01 证书到期日 -- -- 2021-05-01 2021-03-31 20
2021-2000年中国居民人均可支配收入大全（全国、农村、城镇及收入比）
最新发布
04-10
22-09-20]. [2]井波,倪子怡,赵丽瑶,刘凯.城乡收入差距加剧还是抑制 了大气污染?[J].中国人口·资源与环境,2021,31(10):130-138 . [3]葛和平,吴福象.中国贫富差距扩大化的演化脉络与机制分析[J].现代经济 探讨,2019...
algorithm-notes
03-28
03-22审查树2021-03-21审查树2021-03-20复查二元搜索2021-03-19堆种类2021-03-18大批DP2021-03-17DP2021-03-16DP2021-03-15DP2021-03-14DP2021-03-13DP2021-03-12贪婪的DP2021-03-11DP2021-03-10DP2021-03-08DP2021-...
使用python中的pymsql完成如下：表结构与数据创建 1. 建立 `users` 表和 `orders` 表。 `users` 表有用户ID、用户名、年龄字段，（id，name，age） `orders` 表有订单ID、订单日期、订单金额，用户id字段。（id，order_date，amount，user_id） 2 两表的id作为主键，`orders` 表用户id为users的外键 3 插入数据 `users` (1, '张三', 18), (2, '李四', 20), (3, '王五', 22), (4, '赵六', 25), (5, '钱七', 28); `orders` (1, '2021-09-01', 500, 1), (2, '2021-09-02', 1000, 2), (3, '2021-09-03', 600, 3), (4, '2021-09-04', 800, 4), (5, '2021-09-05', 1500, 5), (6, '2021-09-06', 1200, 3), (7, '2021-09-07', 2000, 1), (8, '2021-09-08', 300, 2), (9, '2021-09-09', 700, 5), (10, '2021-09-10', 900, 4); 查询语句 1. 查询订单总金额 2. 查询所有用户的平均年龄，并将结果四舍五入保留两位小数。 3. 查询订单总数最多的用户的姓名和订单总数。 4. 查询所有不重复的年龄。 5. 查询订单日期在2021年9月1日至9月4日之间的订单总金额。 6. 查询年龄不大于25岁的用户的订单数量，并按照降序排序。 7. 查询订单总金额排名前3的用户的姓名和订单总金额。 8. 查询订单总金额最大的用户的姓名和订单总金额。 9. 查询订单总金额最小的用户的姓名和订单总金额。 10. 查询所有名字中含有“李”的用户，按照名字升序排序。 11. 查询所有年龄大于20岁的用户，按照年龄降序排序，并只显示前5条记录。 12. 查询每个用户的订单数量和订单总金额，并按照总金额降序排序。
06-03
(8, '2021-09-08', 300, 2), (9, '2021-09-09', 700, 5), (10, '2021-09-10', 900, 4) ] for user in users_data: cur.execute('INSERT INTO users VALUES (%s, %s, %s)', user) for order in orders_data: ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值