Skip to content

Correct filename and code to read Moffit supplementary #5

@matiasandina

Description

@matiasandina

It would be nice to have the link to the table, at least as a comment on the line that will try to read the data.

https://www.science.org/doi/suppl/10.1126/science.aau5324/suppl_file/aau5324_moffitt_table-s1.xlsx

The filename in the code is CamelCase but in the source data it's all snake_case, so it creates an error.
Additionally, I couldn't read the file without installing a few things. See here for the type of error I was getting.

Basically, the engine had to be specified. The line that works for me is:

# root_ path was specified to build paths for the whole project
table_s1_df = pd.read_excel(f"{root_path}zenodo/MERFISH/raw_data/aau5324_moffitt_table-s1.xlsx", skiprows=[0,1], header=None, engine='openpyxl')

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions