# Load DistanceMatrix Artifact to DataFrame

**URL:** https://forum.qiime2.org/t/load-distancematrix-artifact-to-dataframe/11660
**Category:** Technical Support
**Tags:** artifact-api, distance-matrix
**Created:** [September 25, 2019, 10:46am UTC](https://forum.qiime2.org/t/load-distancematrix-artifact-to-dataframe/11660 "2019-09-25T10:46:46Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Marija\_Durdevic](https://forum.qiime2.org/user_avatar/forum.qiime2.org/marija_durdevic/32/4345_2.png) [@Marija\_Durdevic](https://forum.qiime2.org/u/Marija_Durdevic)
#### Post date: [September 25, 2019, 10:46am UTC](https://forum.qiime2.org/t/load-distancematrix-artifact-to-dataframe/11660/1 "2019-09-25T10:46:46Z")

</div>

Hi all,

I am trying to load DistanceMatrix Artifact to Pandas DataFrame:  
Artifact.load("jaccarddistancematrix.qza").view(pd.DataFrame)

Exception: No transformation from \<class 'qiime2.plugin.model.directory\_format.DistanceMatrixDirectoryFormat'\> to \<class 'pandas.core.frame.DataFrame'\>

Any suggestion on how to do it?

Thanks,  
Marija

---

<div class="post-metadata">

### Author: ![jwdebelius](https://forum.qiime2.org/user_avatar/forum.qiime2.org/jwdebelius/32/9655_2.png) [@jwdebelius](https://forum.qiime2.org/u/jwdebelius)
#### Post date: [September 25, 2019, 10:48am UTC](https://forum.qiime2.org/t/load-distancematrix-artifact-to-dataframe/11660/2 "2019-09-25T10:48:06Z")

</div>

Hi @Marija_Durdevic,

Welcome to the forum!

You need to convert the distance matrix into a scikit-bio distance matrix object, and then you can convert to a dataframe from there:

```auto
import pandas as pd
from skbio import DistanceMatrix
from qiime2 import Artifact

jaccard_dm = Artifact.load(“jaccarddistancematrix.qza”).view(DistanceMatrix)
jaccard_df = jaccard_dm.to_data_frame()

```

Best,  
Justine

---

<div class="post-metadata">

### Author: ![Marija\_Durdevic](https://forum.qiime2.org/user_avatar/forum.qiime2.org/marija_durdevic/32/4345_2.png) [@Marija\_Durdevic](https://forum.qiime2.org/u/Marija_Durdevic)
#### Post date: [September 25, 2019, 10:51am UTC](https://forum.qiime2.org/t/load-distancematrix-artifact-to-dataframe/11660/3 "2019-09-25T10:51:29Z")

</div>

Hi jwdebelius,

Thanks for quick response!  
Best,  
Marija