IDC Spine-Mets-CT-SEG: Metastatic disease, Bladder Cancer, Breast Cancer and 6 more CT (55 patients): sample notebook

A worked notebook for IDC Spine-Mets-CT-SEG: Metastatic disease, Bladder Cancer, Breast Cancer and 6 more CT (55 patients), with 5 code cells and the output each one printed. On Scigantic it opens in a hosted JupyterLab with the dataset already mounted, so nothing is downloaded first.

Provider
NCI Imaging Data Commons; Spine-Mets-CT-SEG contributors; tables and sample by Scigantic
License
Per series (series.parquet license_short_name): CC BY 4.0 110. Cite the source DOI(s) and the IDC.
Size
6 parquet tables plus 1 sample DICOM files (9 MB)
Stored at
Amazon S3, s3://scigantic-idc-open/spine_mets_ct_seg (us-east-1)
Access
Free and public. No account with the data provider is needed.
DOI
10.7937/kh36-ds04

The notebook

Spine-Mets-CT-SEG on the Imaging Data Commons: 55 patients, 110 series, 19.88 GB

Metastatic disease, Bladder Cancer, Breast Cancer, Colon Cancer, Kidney Cancer, Lung Cancer, Prostate Cancer, Soft-tissue Sarcoma, Skin Cancer imaging of the bone from the NCI Imaging Data Commons (IDC). Series by modality: SEG 55, CT 55.

This mount is the collection's index plus a real sample, not the collection: series.parquet (one row per DICOM series, with the public S3 location of each), studies.parquet, patients.parquet, the IDC clinical tables, and sample/ folders holding one SEG series (CC BY 4.0). Anything else is one anonymous S3 read away. README.md and BUILD_REPORT.json at the mount root say exactly how this was built (idc-index, IDC v25).

The code below reads all of it with the scigantic-nci package (pip install "scigantic-nci[dicom]", already installed in this image): from scigantic_nci import idc, then calls such as idc.series("spine_mets_ct_seg"), idc.read_sample and idc.pull_series. Run anywhere else, the same calls read s3://scigantic-idc-open/spine_mets_ct_seg/ anonymously.

import os, json
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import pydicom
from scigantic_nci import idc, NciError
plt.rcParams['figure.dpi'] = 72  # keeps the saved figures small enough for the notebook preview
try:
    from matplotlib_inline.backend_inline import set_matplotlib_formats
    set_matplotlib_formats('jpeg')  # slide renders are photographic; JPEG is a fifth the size of PNG here
except ImportError:
    pass

C = 'spine_mets_ct_seg'
# scigantic_nci reads the mounted archive when its BUILD_REPORT.json names this collection, else s3://scigantic-idc-open/<collection>/ anonymously.
M = os.environ.get('SCIGANTIC_MOUNT_PATH', '/mnt/archive')
on_mount = os.path.exists(f'{M}/BUILD_REPORT.json') and json.load(open(f'{M}/BUILD_REPORT.json')).get('collection_id') == C
print('reading', C, 'from', M if on_mount else f's3://scigantic-idc-open/{C}/')

report = idc.report(C)
series = idc.series(C)  # one row per DICOM series, with its public S3 location
patients = idc.patients(C)
studies = idc.studies(C)
print(report['collection_name'], '| IDC', report['idc_data_version'], '| built', report['built_at'][:10])
print(f"{len(patients):,} patients, {len(studies):,} studies, {len(series):,} series, {series.series_size_MB.sum()/1024:,.1f} GB in the IDC buckets\n")
by_mod = series.groupby('Modality').agg(series=('SeriesInstanceUID', 'count'), patients=('PatientID', 'nunique'), GB=('series_size_MB', lambda s: round(s.sum() / 1024, 2))).sort_values('series', ascending=False)
print(by_mod.to_string())
fig, ax = plt.subplots(figsize=(7, 3))
by_mod['patients'].plot.bar(ax=ax, color='#4a6fa5'); ax.set_ylabel('patients'); ax.set_title(f"{report['collection_name']}: patients per modality"); plt.tight_layout()

Output:

reading spine_mets_ct_seg from /mnt/archive
Spine-Mets-CT-SEG | IDC v25 | built 2026-11-17
55 patients, 55 studies, 110 series, 19.9 GB in the IDC buckets

          series  patients     GB
Modality                         
CT            55        55  18.29
SEG           55        55   1.60

1. Studies and patients

A study is one imaging visit (all series acquired together); a patient may have several. studies.parquet collapses the series table to one row per study with the modalities present, patients.parquet to one row per patient.

print('Studies per patient:'); print(patients.n_studies.describe()[['min', '50%', 'max']].to_string())
print('\nModality combinations per study (top 8):'); print(studies.modalities.value_counts().head(8).to_string())
sex = patients.PatientSex.replace('', np.nan).dropna()
if len(sex): print('\nPatientSex:', sex.value_counts().to_dict())
ages = pd.to_numeric(series.PatientAge.dropna().astype(str).str.extract(r'(\d+)')[0], errors='coerce')
if ages.notna().sum() > 10: print(f'PatientAge at imaging: median {ages.median():.0f} y (IQR {ages.quantile(.25):.0f}-{ages.quantile(.75):.0f}) on {ages.notna().sum():,} series')
if 'BodyPartExamined' in series: print('\nBodyPartExamined:', series.BodyPartExamined.dropna().value_counts().head(6).to_dict())
print('\nLicenses (per series):', series.license_short_name.value_counts().to_dict())

Output:

Studies per patient:
min    1.0
50%    1.0
max    1.0

Modality combinations per study (top 8):
modalities
CT, SEG    55

PatientSex: {'M': 26, 'F': 14}
PatientAge at imaging: median 67 y (IQR 58-73) on 110 series

BodyPartExamined: {'SPINE': 102, 'ABDOMEN': 4, 'CHEST': 2, 'PELVIS': 2}

Licenses (per series): {'CC BY 4.0': 110}

2. Pull the smallest CT series from IDC and open it

Nothing is under sample/ on this mount, so the cell below reads the smallest CT series straight from IDC's public bucket into the pod's /tmp (anonymous S3, no credentials). Every row of series.parquet has aws_bucket and crdc_series_uuid; the objects under that prefix are the series' instances, one .dcm per slice. idc.pull_series(row, dest) downloads them and returns the local paths, which pydicom reads below. Uncompressed transfer syntaxes are preferred so the read needs no decoder plugin. Check series_size_MB before pulling a bigger one: a pod has a few GB of local disk.

cand = idc.series(C, modality='CT')  # the modality filter is pushed down to parquet
if 'CT' in ('CT', 'MR', 'PT') and (cand.instanceCount >= 10).any():
    cand = cand[cand.instanceCount >= 10]  # a real stack, not a scout
cand = cand.assign(_compressed=cand.transfer_syntax_name.fillna('').str.contains('JPEG|RLE', regex=True))
row = cand.sort_values(['_compressed', 'series_size_MB']).iloc[0]
print(row.PatientID, row.Modality, int(row.instanceCount), 'instances,', round(idc.series_size(row), 1), 'MB,', row.license_short_name, '->', row.series_aws_url)
print('IDC viewer:', idc.viewer_url(row))
folder = '/tmp/idc_pull/' + row.crdc_series_uuid
files = idc.pull_series(row, folder)  # anonymous read of s3://<aws_bucket>/<crdc_series_uuid>/, folder marker skipped
print(len(files), 'files ->', folder)
# scigantic_nci returns file paths for a pulled series (read_sample only reads the mirrored samples), so pydicom stacks them here
ds = [pydicom.dcmread(f) for f in files]
ds = [d for d in ds if 'PixelData' in d]
try:
    ds[0].pixel_array
except RuntimeError as e:  # compressed transfer syntax with no decoder plugin in this image
    print(f'This series is stored as {ds[0].file_meta.TransferSyntaxUID.name}; this image cannot decode it (pip install "pylibjpeg[all]" adds the decoder). Skipping the render.')
    ds = []
if ds:
    ds.sort(key=lambda d: (float(d.ImagePositionPatient[2]) if 'ImagePositionPatient' in d else 0.0, int(d.get('InstanceNumber', 0))))
    def frame(d):
        a = d.pixel_array
        return a[a.shape[0] // 2] if int(d.get('NumberOfFrames', 1) or 1) > 1 else a  # multi-frame instance (grayscale or RGB): middle frame
    shapes = sorted({frame(d).shape for d in ds})
    if len(shapes) == 1 and len(ds) >= 3:
        vol = np.stack([frame(d) for d in ds]).astype(np.float32)
        vol = vol * float(ds[0].get('RescaleSlope', 1)) + float(ds[0].get('RescaleIntercept', 0))  # Hounsfield units
        lo, hi = (-160, 240) if ds[0].Modality == 'CT' else (np.percentile(vol, 1), np.percentile(vol, 99))
        picks = [(vol[i], f'slice {i + 1}/{len(ds)}') for i in (len(ds) // 4, len(ds) // 2, 3 * len(ds) // 4)]
    else:  # 2D modalities or a series that mixes image sizes (scouts, crops): show instances one by one
        picks = []
        for d in ds[:3]:
            img = frame(d).astype(np.float32) * float(d.get('RescaleSlope', 1)) + float(d.get('RescaleIntercept', 0))
            picks.append((img, f'{d.get("SeriesDescription", "")} {img.shape[1]}x{img.shape[0]}'))
        vol = np.concatenate([p[0].ravel() for p in picks]); lo, hi = np.percentile(vol, 1), np.percentile(vol, 99)
    d0 = ds[0]
    print(f'{d0.Modality} {len(ds)} instances, image shapes {shapes} | spacing {d0.get("PixelSpacing") or d0.get("ImagerPixelSpacing")} mm, slice thickness {d0.get("SliceThickness")} mm | {d0.get("Manufacturer")} {d0.get("ManufacturerModelName")} | {d0.get("SeriesDescription")}')
    fig, axes = plt.subplots(1, len(picks), figsize=(3.6 * len(picks), 3.8))
    for ax, (img, label) in zip(np.atleast_1d(axes), picks):
        ax.imshow(img if img.ndim == 2 else np.clip((img - lo) / max(hi - lo, 1e-6), 0, 1), cmap='gray', vmin=lo, vmax=hi); ax.set_title(label, fontsize=9); ax.axis('off')  # RGB (ultrasound) is scaled to 0-1
    plt.suptitle(f"Spine-Mets-CT-SEG: smallest CT series, patient {row.PatientID} ({row.license_short_name})"); plt.tight_layout()

Output:

13800 CT 221 instances, 116.3 MB, CC BY 4.0 -> s3://idc-open-data/65a7afee-c5bb-4c79-b004-36bff3026bc0/*
IDC viewer: https://viewer.imaging.datacommons.cancer.gov/viewer/1.3.6.1.4.1.14519.5.2.1.141265557749994688235436797481295066966?seriesInstanceUID=1.3.6.1.4.1.14519.5.2.1.55389529677260335463675303341584456700
221 files -> /tmp/idc_pull/65a7afee-c5bb-4c79-b004-36bff3026bc0
CT 221 instances, image shapes [(512, 512)] | spacing [.92578125, .92578125] mm, slice thickness 3 mm | SIEMENS SOMATOM Confidence | SKIN_TO_SKIN_SIM_.5mm_13800 iMAR

3. The sample segmentation

sample/SEG_1.3.6.1.4.1.14519.5.2.1.180875112452681112437503588025540603891/ is a DICOM SEG series of patient 13843 (9.0 MB, CC BY 4.0): a stack of binary frames, one per segment and source slice, with SegmentSequence naming each segment and ReferencedSeriesSequence pointing at the image series it was drawn on. A few collections label ordinary image instances (one label map per slice) as SEG; the cell handles both. idc.sample_files lists the files; on the mount they are read in place, and elsewhere the same series is pulled from IDC with idc.pull_series. The source image series can be pulled from IDC the same way as any other row of series.parquet.

# scigantic_nci has no SEG reader, and read_sample decodes one frame per instance, which pydicom cannot do for some 1-bit SEG objects,
# so the SEG files are read whole with pydicom: in place on the mount (sample_files gives paths relative to the archive root), else pulled from IDC.
seg_sample = idc.samples(C).query("modality == 'SEG'").iloc[0]
if on_mount:
    seg_files = [os.path.join(M, f) for f in idc.sample_files(C, 'SEG')]
else:
    seg_files = idc.pull_series(series[series.SeriesInstanceUID == seg_sample.SeriesInstanceUID].iloc[0], '/tmp/idc_pull/' + seg_sample.SeriesInstanceUID)
seg_ds = [pydicom.dcmread(f) for f in seg_files]
seg = seg_ds[0]
if 'SegmentSequence' in seg:  # a DICOM Segmentation object
    print(seg.Modality, seg.get('SeriesDescription'), '|', int(seg.get('NumberOfFrames', 1)), 'frames of', seg.Rows, 'x', seg.Columns, '|', seg.get('ContentCreatorName'))
    print('segments:', [(int(x.SegmentNumber), str(x.SegmentLabel), str(x.get('SegmentAlgorithmType'))) for x in seg.SegmentSequence][:8])
    mask = seg.pixel_array
else:  # labelled SEG but stored as ordinary images: one label map per slice
    seg_ds.sort(key=lambda d: (float(d.ImagePositionPatient[2]) if 'ImagePositionPatient' in d else 0.0, int(d.get('InstanceNumber', 0))))
    print(seg.Modality, seg.get('SeriesDescription'), '|', len(seg_ds), seg.SOPClassUID.name, 'instances of', seg.Rows, 'x', seg.Columns, '(label maps, not a Segmentation object)')
    mask = np.stack([d.pixel_array for d in seg_ds])
    values, counts = np.unique(mask, return_counts=True)
    mask = mask != values[counts.argmax()]  # label maps carry a nonzero background value; everything else is labelled
ref = seg.ReferencedSeriesSequence[0].SeriesInstanceUID if 'ReferencedSeriesSequence' in seg else None
src = series[series.SeriesInstanceUID == ref]
if len(src):
    r = src.iloc[0]
    print(f'drawn on the {r.Modality} series of patient {r.PatientID}: {int(r.instanceCount)} instances, {r.series_size_MB:.1f} MB, {r.license_short_name}, {r.series_aws_url}')
mask = (mask[None] if mask.ndim == 2 else mask) > 0
i = int(mask.reshape(mask.shape[0], -1).sum(1).argmax())  # the frame with the most labelled pixels
print(f'{int(mask.sum()):,} labelled pixels over {mask.shape[0]} frames; densest frame {i + 1}')
fig, ax = plt.subplots(figsize=(3.8, 3.8)); ax.imshow(mask[i], cmap='gray'); ax.axis('off'); ax.set_title(f"Spine-Mets-CT-SEG: sample SEG, frame {i + 1}", fontsize=9); plt.tight_layout()

Output:

SEG Spine Segmentation | 270 frames of 512 x 512 | 
segments: [(1, 'T1 vertebra', 'SEMIAUTOMATIC'), (2, 'T2 vertebra', 'SEMIAUTOMATIC'), (3, 'T3 vertebra', 'SEMIAUTOMATIC'), (4, 'T4 vertebra', 'SEMIAUTOMATIC'), (5, 'T5 vertebra', 'SEMIAUTOMATIC'), (6, 'T6 vertebra', 'SEMIAUTOMATIC'), (7, 'T7 vertebra', 'SEMIAUTOMATIC'), (8, 'T8 vertebra', 'SEMIAUTOMATIC')]
drawn on the CT series of patient 13843: 242 instances, 127.4 MB, CC BY 4.0, s3://idc-open-data/4f96abba-871f-468f-b1bd-94622897bd92/*
188,604 labelled pixels over 270 frames; densest frame 261

4. Clinical tables

IDC ships 1 clinical table(s) for this collection (spine_mets_ct_seg_clinical; idc.clinical_tables lists them), keyed by dicom_patient_id = PatientID. clinical/dictionary.parquet (idc.clinical_dictionary) carries the human-readable label and the coded values for every column; coded columns store the code.

clin = idc.clinical(C, 'spine_mets_ct_seg_clinical')
dictionary = idc.clinical_dictionary(C)
print(clin.shape, 'rows x cols in', 'spine_mets_ct_seg_clinical')
print(dictionary[dictionary.short_table_name == 'spine_mets_ct_seg_clinical'][['column', 'column_label']].head(15).to_string(index=False))
joined = patients.merge(clin, left_on='PatientID', right_on='dicom_patient_id', how='left')
print(f'\n{joined.dicom_patient_id.notna().sum()} of {len(patients)} imaged patients have a clinical row')

Output:

(55, 14) rows x cols in spine_mets_ct_seg_clinical
                column                                             column_label
      dicom_patient_id                          idc_provenance_dicom_patient_id
          source_batch                              idc_provenance_source_batch
                  case                                             \nPatient ID
                 age_y                               \nSubject Age at Diagnosis
                   sex                                   \nPerson Sex at Birth 
              height_m                                         \nPerson Height 
             weight_kg                                         \nPerson Weight 
             bmi_kg_m2                           \nPerson Body Mass Index Value
        primary_cancer \nMetastasis Primary Neoplasm Tissue or Organ of Origin 
vertebrae_with_lesions                              \nNeoplasm Vertebra Lesion 
               blastic           \nImaging Osteoblastic Metastatic Bone Lesion 
                 lytic              \nImaging Osteolytic Metastatic Bone Lesion
                 mixed                   \nImaging Mixed Metastatic Bone Lesion
...

Try this in the AI assistant

The chat panel is prefilled with the first of these.

Licenses are per series (license_short_name in series.parquet). Cite the collection DOI(s) in README.md and the IDC papers (Fedorov et al. 2021, 2023) when you publish.

Run it

Open this notebook to run it, see the dataset page for the full description, or browse the full catalog.