如何使用Python将列表转换为表?

Question

我有一个包含50个样本id的列表。列表的部分如下所示:

[{'query': '100008567',
'MGI': 'MGI:3641621',
'_id': '100008567',
'_version': 1,
'accession': {'genomic': 'AC167245.2',
'protein': 'BAC32506.1',
'rna': ['AK045662.1', 'AK045826.1'],
'translation': {'protein': 'BAC32506.1', 'rna': 'AK045826.1'}},
'entrezgene': '100008567',
'name': 'predicted gene 14964',
'reporter': {'MG-U74Bv2': '116585_at',
'MTA-1_0': 'TC1900001011.mm.1',
'MoEx-1_0': ['6867861', '6871243'],
'MoGene-1_1': '10465424',
'MoGene-2_1': '17362028',
'Mouse430_2': ['1435908_at', '1456406_at']},
'symbol': 'Gm14964',
'taxid': 10090,
'type_of_gene': 'unknown',
'unigene': 'Mm.440261'},
{'query': '100017',
'MGI': 'MGI:2140175',
'_id': '100017',
'_version': 4,
'accession': {'genomic': ['AL627122.18',
'AL645531.10',
'CH466552.2',
'NC_000070.7'],
'protein': ['AAH21467.1',
'AAH66808.1',
'AAH67411.1',
'BAC26238.1',
'BAE28493.1',
'BAE35380.1',
'BAE39396.1',
'BAE41296.1',
'EDL30001.1',
'NP_663529.2',
'Q8C142.3',
'XP_006538486.1'],
'rna': ['AK029008.1',
'AK085671.1',
'AK148340.1',
'AK159800.1',
'AK167290.1',
'AK169675.1',
'AK190264.1',
'AK191241.1',
'BC021467.1',
'BC066808.1',
'BC067411.1',
'BY124598.1',
'BY435601.1',
'NM_145554.2',
'XM_006538423.5'],
'translation': [{'protein': 'BAC26238.1', 'rna': 'AK029008.1'},
{'protein': 'BAE39396.1', 'rna': 'AK167290.1'},
{'protein': 'NP_663529.2', 'rna': 'NM_145554.2'},
{'protein': 'AAH21467.1', 'rna': 'BC021467.1'},
{'protein': 'BAE28493.1', 'rna': 'AK148340.1'},
{'protein': 'BAE35380.1', 'rna': 'AK159800.1'},
{'protein': 'XP_006538486.1', 'rna': 'XM_006538423.5'},
{'protein': 'AAH67411.1', 'rna': 'BC067411.1'},
{'protein': 'AAH66808.1', 'rna': 'BC066808.1'},
{'protein': 'BAE41296.1', 'rna': 'AK169675.1'}]},
'alias': ['A', 'AA691260', 'ARH2', 'Ar', 'Arh', 'Arh1', 'FHCB1', 'FHCB2'],
'ensembl': {'gene': 'ENSMUSG00000037295',
'protein': 'ENSMUSP00000036749',
'transcript': ['ENSMUST00000037828',
'ENSMUST00000140678',
'ENSMUST00000148479'],
'translation': [{'protein': 'ENSMUSP00000036749',
'rna': 'ENSMUST00000037828'}],
'type_of_gene': 'protein_coding'},
'entrezgene': '100017',
'exons': [{'cdsend': 134767900,
'cdsstart': 134747051,
'chr': '4',
'position': [[134745411, 134747199],
[134748281, 134748316],
[134749336, 134749467],
[134749958, 134750042],
[134750381, 134750454],
[134755192, 134755307],
[134757340, 134757453],
[134758918, 134759061],
[134767815, 134768004]],
'strand': -1,
'transcript': 'NM_145554',
'txend': 134768004,
'txstart': 134745411}],
'exons_mm9': [{'cdsend': 134323815,
'cdsstart': 134302966,
'chr': '4',
'position': [[134301326, 134303114],
[134304196, 134304231],
[134305251, 134305382],
[134305873, 134305957],
[134306296, 134306369],
[134311107, 134311222],
[134313255, 134313368],
[134314833, 134314976],
[134323730, 134323919]],
'strand': -1,
'transcript': 'NM_145554',
'txend': 134323919,
'txstart': 134301326}],
'generif': [{'pubmed': 12746448,
'text': 'results are consistent with LDL receptor adaptor protein(ARH) playing a critical and specific role in low density lipoprotein receptor endocytosis in the liver'},
{'pubmed': 15472122,
'text': 'Hepatocytes do not take-up LDL in vivo without ARH protein, but they normally catabolize LDL in vitro. Thus, the requirement of ARH protein for proper functioning of the LDLR is not cell-specific, but rather may depend on the cellular environment.'},
{'pubmed': 16339113,
'text': 'the LDL receptor alone can account for the clearance of apoE-containing lipoproteins in mice, and the contribution of other receptors is minimal, and b) defects in either increase the sensitivity to apoE-induced hypertriglyceridemia in mice.'},
{'pubmed': 17727637,
'text': 'Taken together, our data suggest that ARH is a multifunctional protein whose spectrum of function in the brain goes beyond the traditionally known metabolism of lipoproteins, and that ARH may be locally synthesized in the axon.'},
{'pubmed': 18417616,
'text': 'the endocytic adaptor protein ARH associates with motor and centrosomal proteins and is involved in centrosome assembly and cytokinesis'},
{'pubmed': 19005074,
'text': 'Loss of gamma-secretase function decreased endocytosis of low-density lipoprotein (LDL) receptor'},
{'pubmed': 19841541,
'text': 'ARH marks ROMK for clathrin-dependent endocytosis, in concert with the demands of potassium homeostasis'},
{'pubmed': 23564733,
'text': 'cells that depend upon ARH for LDL uptake can control which lipoproteins are internalized by their LDLRs through changes in nitric oxide.'},
{'pubmed': 27005486,
'text': 'The combination of Arh and Dab2 is responsible for the majority of adaptor function in LDLR endocytosis and LDLR-mediated cholesterol homeostasis.'}],
'genomic_pos': {'chr': '4',
'end': 134768024,
'ensemblgene': 'ENSMUSG00000037295',
'start': 134741554,
'strand': -1},
'genomic_pos_mm9': {'chr': '4',
'end': 134323939,
'start': 134300650,
'strand': -1},
'go': {'BP': [{'evidence': 'IEA',
'gocategory': 'BP',
'id': 'GO:0006629',
'term': 'lipid metabolic process'},
{'evidence': 'IEA',
'gocategory': 'BP',
'id': 'GO:0006897',
'term': 'endocytosis'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:0006898',
'term': 'receptor-mediated endocytosis'},
{'evidence': 'IEA',
'gocategory': 'BP',
'id': 'GO:0008202',
'term': 'steroid metabolic process'},
{'evidence': 'IEA',
'gocategory': 'BP',
'id': 'GO:0008203',
'term': 'cholesterol metabolic process'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:0031623',
'term': 'receptor internalization'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:0034383',
'term': 'low-density lipoprotein particle clearance'},
{'evidence': 'IMP',
'gocategory': 'BP',
'id': 'GO:0042632',
'pubmed': 12746448,
'term': 'cholesterol homeostasis'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:0042632',
'term': 'cholesterol homeostasis'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:0042982',
'term': 'amyloid precursor protein metabolic process'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:0043393',
'term': 'regulation of protein binding'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:0048260',
'term': 'positive regulation of receptor-mediated endocytosis'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:0071345',
'term': 'cellular response to cytokine stimulus'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:0090118',
'term': 'receptor-mediated endocytosis involved in cholesterol transport'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:1903076',
'term': 'regulation of protein localization to plasma membrane'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:1904707',
'term': 'positive regulation of vascular associated smooth muscle cell proliferation'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:1905581',
'term': 'positive regulation of low-density lipoprotein particle clearance'},
{'evidence': 'ISO',
'gocategory': 'BP',
'id': 'GO:1905602',
'term': 'positive regulation of receptor-mediated endocytosis involved in cholesterol transport'}],
'CC': [{'evidence': 'IDA',
'gocategory': 'CC',
'id': 'GO:0005737',
'pubmed': 17727637,
'term': 'cytoplasm'},
{'evidence': 'IBA',
'gocategory': 'CC',
'id': 'GO:0005769',
'pubmed': 21873635,
'term': 'early endosome'},
{'evidence': 'IDA',
'gocategory': 'CC',
'id': 'GO:0005769',
'pubmed': 12746448,
'term': 'early endosome'},
{'evidence': 'ISO',
'gocategory': 'CC',
'id': 'GO:0005769',
'term': 'early endosome'},
{'evidence': 'ISO',
'gocategory': 'CC',
'id': 'GO:0005829',
'term': 'cytosol'},
{'evidence': 'IDA',
'gocategory': 'CC',
'id': 'GO:0005883',
'pubmed': 17727637,
'term': 'neurofilament'},
{'evidence': 'ISO',
'gocategory': 'CC',
'id': 'GO:0009898',
'term': 'cytoplasmic side of plasma membrane'},
{'evidence': 'ISO',
'gocategory': 'CC',
'id': 'GO:0009925',
'term': 'basal plasma membrane'},
{'evidence': 'ISO',
'gocategory': 'CC',
'id': 'GO:0030424',
'term': 'axon'},
{'evidence': 'ISO',
'gocategory': 'CC',
'id': 'GO:0055037',
'term': 'recycling endosome'}],
'MF': [{'category': 'MF',
'evidence': 'IPI',
'id': 'GO:0001540',
'pubmed': 17727637,
'term': 'amyloid-beta binding'},
{'category': 'MF',
'evidence': 'ISO',
'id': 'GO:0001540',
'term': 'amyloid-beta binding'},
{'category': 'MF',
'evidence': 'ISO',
'id': 'GO:0001784',
'term': 'phosphotyrosine residue binding'},
{'category': 'MF',
'evidence': 'ISO',
'id': 'GO:0005102',
'pubmed': 12221107,
'term': 'signaling receptor binding'},
{'category': 'MF',
'evidence': 'IPI',
'id': 'GO:0005515',
'pubmed': [12746448, 17727637],
'term': 'protein binding'},
{'category': 'MF',
'evidence': 'ISO',
'id': 'GO:0005546',
'term': 'phosphatidylinositol-4,5-bisphosphate binding'},
{'category': 'MF',
'evidence': 'ISO',
'id': 'GO:0030159',
'term': 'signaling receptor complex adaptor activity'},
{'category': 'MF',
'evidence': 'ISO',
'id': 'GO:0030276',
'pubmed': 12221107,
'term': 'clathrin binding'},
{'category': 'MF',
'evidence': 'ISO',
'id': 'GO:0035591',
'term': 'signaling adaptor activity'},
{'category': 'MF',
'evidence': 'ISO',
'id': 'GO:0035612',
'term': 'AP-2 adaptor complex binding'},
{'category': 'MF',
'evidence': 'ISO',
'id': 'GO:0035615',
'term': 'clathrin adaptor activity'},
{'category': 'MF',
'evidence': 'ISO',
'id': 'GO:0035650',
'term': 'AP-1 adaptor complex binding'},
{'category': 'MF',
'evidence': 'ISO',
'id': 'GO:0050750',
'term': 'low-density lipoprotein particle receptor binding'}]},
'homologene': {'genes': [[7955, 791153],
[8364, 549868],
[9031, 419589],
[9544, 713032],
[9598, 739347],
[9606, 26119],
[9615, 612219],
[9913, 511199],
[10090, 100017],
[10116, 500564]],
'id': 9219},
'interpro': [{'desc': 'PTB/PI domain',
'id': 'IPR006020',
'short_desc': 'PTB/PI_dom'},
{'desc': 'PH-like domain superfamily',
'id': 'IPR011993',
'short_desc': 'PH-like_dom_sf'}],
'ipi': 'IPI00454119',
'map_location': '4|4 D3',
'name': 'low density lipoprotein receptor adaptor protein 1',
'other_names': ['LDL receptor adaptor protein',
'autosomal recessive hypercholesterolemia protein homolog',
'low density lipoprotein receptor adapter protein 1'],
'pantherdb': {'MGI': 'MGI:2140175',
'_license': 'http://pantherdb.org/tou.jsp',
'ortholog': [{'RGD': '1563417',
'ortholog_type': 'LDO',
'panther_family': 'PTHR11232',
'taxid': 10116,
'uniprot_kb': 'D3ZAR1'},
{'Ensembl': 'ENSGALG00000016508',
'ortholog_type': 'O',
'panther_family': 'PTHR11232',
'taxid': 9031,
'uniprot_kb': 'F1NUC5'},
{'Ensembl': 'ENSGALG00000001051',
'ortholog_type': 'LDO',
'panther_family': 'PTHR11232',
'taxid': 9031,
'uniprot_kb': 'E1BQU5'},
{'ZFIN': 'ZDB-GENE-041014-145',
'ortholog_type': 'O',
'panther_family': 'PTHR11232',
'taxid': 7955,
'uniprot_kb': 'A0A0R4IVW6'},
{'ZFIN': 'ZDB-GENE-030328-13',
'ortholog_type': 'LDO',
'panther_family': 'PTHR11232',
'taxid': 7955,
'uniprot_kb': 'Q1L868'},
{'ZFIN': 'ZDB-GENE-070112-1012',
'ortholog_type': 'O',
'panther_family': 'PTHR11232',
'taxid': 7955,
'uniprot_kb': 'F1R8R1'},
{'MGI': '1917979',
'ortholog_type': 'P',
'panther_family': 'PTHR11232',
'taxid': 10090,
'uniprot_kb': 'Q9D3A8'},
{'MGI': '107423',
'ortholog_type': 'P',
'panther_family': 'PTHR11232',
'taxid': 10090,
'uniprot_kb': 'Q9QZS3'},
{'MGI': '894702',
'ortholog_type': 'P',
'panther_family': 'PTHR11232',
'taxid': 10090,
'uniprot_kb': 'O08919'},
{'MGI': '1926555',
'ortholog_type': 'P',
'panther_family': 'PTHR11232',
'taxid': 10090,
'uniprot_kb': 'Q9ERE9'},
{'MGI': '1309464',
'ortholog_type': 'P',
'panther_family': 'PTHR11232',
'taxid': 10090,
'uniprot_kb': 'Q9WVI9'},
{'MGI': '1920407',
'ortholog_type': 'P',
'panther_family': 'PTHR11232',
'taxid': 10090,
'uniprot_kb': 'Q8K2A1'}],
'uniprot_kb': 'Q8C142'},
'pathway': {'kegg': [{'id': 'mmu04144',
'name': 'Endocytosis - Mus musculus (mouse)'},
{'id': 'mmu04979',
'name': 'Cholesterol metabolism - Mus musculus (mouse)'}],
'reactome': [{'id': 'R-MMU-174824',
'name': 'Plasma lipoprotein assembly, remodeling, and clearance'},
{'id': 'R-MMU-199991', 'name': 'Membrane Trafficking'},
{'id': 'R-MMU-382551', 'name': 'Transport of small molecules'},
{'id': 'R-MMU-5653656', 'name': 'Vesicle-mediated transport'},
{'id': 'R-MMU-8856825',
'name': 'Cargo recognition for clathrin-mediated endocytosis'},
{'id': 'R-MMU-8856828', 'name': 'Clathrin-mediated endocytosis'},
{'id': 'R-MMU-8964026', 'name': 'Chylomicron clearance'},
{'id': 'R-MMU-8964038', 'name': 'LDL clearance'},
{'id': 'R-MMU-8964043', 'name': 'Plasma lipoprotein clearance'}]},
'pfam': 'PF00640',
'prosite': 'PS01179',
'reagent': {'GNF_mm+hs-MGC': [{'id': 'GNF020344', 'relationship': 'is'},
{'id': 'GNF020345', 'relationship': 'is'},
{'id': 'GNF020346', 'relationship': 'is'}],
'GNF_mm+hs_RetroCDNA': {'id': 'GNF236883', 'relationship': 'is'}},
'refseq': {'genomic': 'NC_000070.7',
'protein': ['NP_663529.2', 'XP_006538486.1'],
'rna': ['NM_145554.2', 'XM_006538423.5'],
'translation': [{'protein': 'XP_006538486.1', 'rna': 'XM_006538423.5'},
{'protein': 'NP_663529.2', 'rna': 'NM_145554.2'}]},
'reporter': {'GNF1M': 'gnf1m19183_a_at',
'MG-U74Bv2': '107598_at',
'MTA-1_0': 'TC0400003746.mm.1',
'MoEx-1_0': '6926029',
'MoGene-1_1': '10517301',
'MoGene-2_1': '17431350',
'Mouse430_2': ['1424378_at', '1457162_at']},
'retired': 230816,
'symbol': 'Ldlrap1',
'taxid': 10090,
'type_of_gene': 'protein-coding',
'unigene': ['Mm.482148', 'Mm.27486'],
'uniprot': {'Swiss-Prot': 'Q8C142'}}]

从这个列表中，我想只提取包含'query'和'name'的键和值作为表形式的输出。

样本输出:

<表类>查询名称100008567预测基因14964100017低密度脂蛋白受体衔接蛋白1

试一下

data = your_data_list

modified_data = [
{'query': d['query'], 'name': d['name']} 
for d in data if d.get('query') and d.get('name')
]
print(modified_data)
# Output
# [{'query': '100008567', 'name': 'predicted gene 14964'}, {'query': '100017', 'name': 'low density lipoprotein receptor adaptor protein 1'}]

刚刚使用了列表推导式。有了它之后，就可以遍历它以在表中显示数据。像这样,

print(f"{'QUERY':20}NAME")
for d in modified_data:
print(f"{d['query']:20}{d['name']}")
# Output
#
# QUERY               NAME
# 100008567           predicted gene 14964
# 100017              low density lipoprotein receptor adaptor protein 1

如果你想在网页中显示，你可以在for循环中实现

假设您有您的addToTable方法，它需要一个查询和一个名称，然后您可以做以下操作:

lst = [{"query": ...... }] # your list of dictionaries
for dic in lst:
if "name" in dic.keys() and "query" in dic.keys():
addToTable(dic["query"], dic["name"])

我会使用这样的循环(queries是您的列表):

for query in queries:
print(f"{query.get('query')=} | {query.get('name')=}")

应该这样做，(至少对于您的示例):

samples = [{'query': '100008567', ...}]
table = {}
for sample in samples:
query = sample["query"]
name = sample["name"]
table[query] = name
print(table)

因为我不知道你说的"表"是什么意思，所以我把它存储为字典。这应该输出:

{100008567: "predicted gene 14964",
100017: "low density lipoprotein receptor adaptor protein 1"}

请注意，我假设查询值在样本列表中出现一次。