In [18]:

    

import os.path as op
import numpy as np
import io3d
import pandas as pd


    

In [19]:

    

DATA_FILE = r"H:\cases.xlsx"
output_path = io3d.datasets.join_path("patient_id.csv")


    

In [20]:

    

df = pd.read_excel(DATA_FILE)[["Simple Patient ID", "Study ID", "Serie"]]
df["Simple Patient ID"] = df["Simple Patient ID"]
df.info()


    

    




<class 'pandas.core.frame.DataFrame'>
RangeIndex: 64 entries, 0 to 63
Data columns (total 3 columns):
Simple Patient ID    64 non-null int64
Study ID             56 non-null object
Serie                23 non-null object
dtypes: int64(1), object(2)
memory usage: 1.6+ KB

In [21]:

    

df.to_csv(output_path, index=False)


    

In [1]:

    

pd.read_csv(output_path)


    

    




---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
<ipython-input-1-94437f3d77a7> in <module>()
----> 1 pd.read_csv(output_path)

NameError: name 'pd' is not defined

In [ ]: