【图像识别】python、sqlite操作
2022/2/14 19:11:38
本文主要是介绍【图像识别】python、sqlite操作,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
''' sqlite3.exe .open imagestags.db # id,filename,tag1,tag1_score,tag2,tag2_score,tag3,tag3_score,tag4,tag4_score,tag5,tag5_score create table imagestags(id integer, filename text, tag1 text, tag1_score REAL, tag2 text, tag2_score REAL, tag3 text, tag3_score REAL, tag4 text, tag4_score REAL, tag5 text, tag5_score REAL); .databases .tables .separator ',' .import 'E:\2000_AI\0000_ImageCluster\1048576_results.csv' imagestags select * from imagestags; select * from sqlite_master where type="table"; select * from sqlite_master where type="table" and name="imagestags"; .schema imagestags ALTER TABLE imagestags ADD COLUMN fullFeature Text; select tag1 || ',' || tag2 || ',' || tag3 || ',' || tag4 || ',' || tag5 from imagestags where id<5; update imagestags set fullFeature = tag1 || ',' || tag2 || ',' || tag3 || ',' || tag4 || ',' || tag5; select fullFeature from imagestags where id<5; select fullFeature from imagestags where fullFeature like '%雪%'; select fullFeature from imagestags where fullFeature like '%丛林%' and fullFeature like '%雪景%'; select id as id,filename as filename,tag1 as tag1,tag1_score as tag1_score,tag2 as tag2,tag2_score as tag2_score,tag3 as tag3,tag3_score as tag3_score,tag4 as tag4,tag4_score as tag4_score,tag5 as tag5,tag5_score as tag5_score from imagestags where fullFeature like '%丛林%' and fullFeature like '%天空%' and fullFeature like '%雪景%'; select id as id,filename as filename,tag1 as tag1,tag1_score as tag1_score,tag2 as tag2,tag2_score as tag2_score,tag3 as tag3,tag3_score as tag3_score,tag4 as tag4,tag4_score as tag4_score,tag5 as tag5,tag5_score as tag5_score from imagestags where fullFeature like '%雪景%' and fullFeature like '%天空%' and fullFeature like '%丛林%' and fullFeature like '%山%'; select id as id,filename as filename,tag1 as tag1,tag1_score as tag1_score,tag2 as tag2,tag2_score as tag2_score,tag3 as tag3,tag3_score as tag3_score,tag4 as tag4,tag4_score as tag4_score,tag5 as tag5,tag5_score as tag5_score from imagestags where fullFeature like '%雪景%' and fullFeature like '%天空%' and fullFeature like '%丛林%' and fullFeature like '%山%' and fullFeature like '%日出日落%'; select ta.* ,tb.NO from imagestags as ta, (select tag1,tag2,tag3 row_number() over(partition by null order by null) as NO from imagestags group by tag1,tag2,tag3) as tb where ta.tag1=tb.tag1 and ta.tag2=tb.tag2 and ta.tag3=tb.tag3 select ta.* ,tb.NO from imagestags as ta, (select tag1,tag2,tag3 row_number() over(partition by null order by null) as NO from imagestags group by tag1,tag2,tag3) as tb where ta.tag1=tb.tag1 and ta.tag2=tb.tag2 and ta.tag3=tb.tag3; select * from( select * from imagestags as ta where ta.tag1 in (select tag1 from imagestags group by tag1 having count(*) >=2) and ta.tag2 in (select tag2 from imagestags group by tag2 having count(*) >=2) and ta.tag3 in (select tag3 from imagestags group by tag3 having count(*) >=2) ) order by tag1,tag2,tag3; select * from( select * from imagestags as ta where ta.tag1 in (select tag1 from imagestags group by tag1 having count(*) >=2) and ta.tag2 in (select tag2 from imagestags group by tag2 having count(*) >=2) and ta.tag3 in (select tag3 from imagestags group by tag3 having count(*) >=2) and ta.tag4 in (select tag4 from imagestags group by tag4 having count(*) >=2) ) order by tag1,tag2,tag3,tag4,tag5; select * from( select * from imagestags as ta where ta.tag1 in (select tag1 from imagestags group by tag1 having count(*) >=2) and ta.tag2 in (select tag2 from imagestags group by tag2 having count(*) >=2) and ta.tag3 in (select tag3 from imagestags group by tag3 having count(*) >=2) and ta.tag4 in (select tag4 from imagestags group by tag4 having count(*) >=2) and ta.tag5 in (select tag5 from imagestags group by tag5 having count(*) >=2)) order by tag1,tag2,tag3,tag4,tag5; '''
这篇关于【图像识别】python、sqlite操作的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-09-18初探Python股票自动化交易:入门指南
- 2024-09-18Python量化入门:轻松掌握量化分析基础与实战
- 2024-09-18Python量化交易:入门指南与实践
- 2024-09-18Python量化交易:入门指南与实战技巧
- 2024-09-14Python人工智能项目实战:从零开始的实践指南
- 2024-09-14探索Python人工智能资料:初学者的指南
- 2024-09-14Python人工智能资料:初学者的全面指南
- 2024-09-13Matplotlib入门:轻松绘制Python数据可视化图表
- 2024-09-13Python人工智能:初学者的入门指南
- 2024-09-13Python人工智能:轻松入门与实践