# WIOD database in Julia

**URL:** https://discourse.julialang.org/t/wiod-database-in-julia/100759
**Category:** Data
**Tags:** question, economics, vscode, data\_structures, input-output
**Created:** [June 23, 2023, 8:46pm UTC](https://discourse.julialang.org/t/wiod-database-in-julia/100759 "2023-06-23T20:46:17Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Guido](https://avatars.discourse-cdn.com/v4/letter/g/b77776/32.png) [@Guido](https://discourse.julialang.org/u/Guido)
#### Post date: [June 23, 2023, 8:46pm UTC](https://discourse.julialang.org/t/wiod-database-in-julia/100759/1 "2023-06-23T20:46:17Z")

</div>

I’m working on World Input-Output Database (WIOD) from Groningen.

Usually, I work this data using STATA. What I have so far is my usual do file template translated in Julia language, but I want to do it in Julia from scratch. Does anyone know a template or paper explaining how is the proper way to work this specific database?

Regards

---

<div class="post-metadata">

### Author: ![nilshg](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nilshg/32/2283_2.png) [@nilshg](https://discourse.julialang.org/u/nilshg)
#### Post date: [June 23, 2023, 9:12pm UTC](https://discourse.julialang.org/t/wiod-database-in-julia/100759/2 "2023-06-23T21:12:02Z")

</div>

The “database” seems to be available as a simple excel file so you could just read it with XLSX.jl, but similarly you can read the Stata format with StatFiles.jl

---

<div class="post-metadata">

### Author: ![Guido](https://avatars.discourse-cdn.com/v4/letter/g/b77776/32.png) [@Guido](https://discourse.julialang.org/u/Guido)
#### Post date: [June 23, 2023, 9:21pm UTC](https://discourse.julialang.org/t/wiod-database-in-julia/100759/3 "2023-06-23T21:21:21Z")

</div>

Thanks for the answer. I was wondering not just how to import the data, but mainly how to work and clean the data following a template as a starter.

---

<div class="post-metadata">

### Author: ![nilshg](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nilshg/32/2283_2.png) [@nilshg](https://discourse.julialang.org/u/nilshg)
#### Post date: [June 25, 2023, 4:08pm UTC](https://discourse.julialang.org/t/wiod-database-in-julia/100759/4 "2023-06-25T16:08:35Z")

</div>

Sorry I misunderstood then. You said you already had your do file translated to Julia, could you explain in a bit more detail what you are missing?
