🔒 Need help in turning a multikey json file to a dataframe

[wise cobalt]

@chrome shell

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[chrome shell]

{
    "file": {
        "archaea": {
            "GCF_014646535.1": {
                "reference": {
                    "fasta_location": "/media/...,
                    "total_ref_GC (%)": 47.0,
                    "tot_ref_length (bp)": 1938654,
                    "Species (KmerFinder)": "Thermocladium_modestius"
                },
                "pb_triatoma_rubida_mapped_archaea_GCF_014646535.1": {
                    "fasta_location": "/media/...",
                    "tot_gc (%)": 48.36,
                    "tot_length (bp)": 91200,
                    "complete": {
                        "GC_results": "GC is in acceptable range",
                        "Genome_size_results": "Genome length is shorter"
                    }
                },
                "alignment data": {
                    "average MapQ": 57,
                    "Total number of exact matches in alignment": 55133,
                    "tot len query": 91200,
                    "tot len vs 85 ref": "No",
                    "alignment_loc": "/media/..."
                }
            }

here is a small example of one of the inner keys

[chrome shell]

!close

[wise cobalt]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.