# Julia academy data science tutorial

**URL:** https://discourse.julialang.org/t/julia-academy-data-science-tutorial/98483
**Category:** New to Julia
**Created:** [May 8, 2023, 3:12pm UTC](https://discourse.julialang.org/t/julia-academy-data-science-tutorial/98483 "2023-05-08T15:12:58Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![VISHWARATH\_T](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/vishwarath_t/32/49212_2.png) [@VISHWARATH\_T](https://discourse.julialang.org/u/VISHWARATH_T)
#### Post date: [May 8, 2023, 3:12pm UTC](https://discourse.julialang.org/t/julia-academy-data-science-tutorial/98483/1 "2023-05-08T15:12:58Z")

</div>

Hello I am not able to execute this command: G[1]

I executed this :  
G = XLSX.readtable(“data/zillow\_data\_download\_april2020.xlsx”,“Sale\_counts\_city”)  
XLSX.DataTable

---

<div class="post-metadata">

### Author: ![Nathan\_Boyer](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/nathan_boyer/32/14825_2.png) [@Nathan\_Boyer](https://discourse.julialang.org/u/Nathan_Boyer)
#### Post date: [May 8, 2023, 3:39pm UTC](https://discourse.julialang.org/t/julia-academy-data-science-tutorial/98483/2 "2023-05-08T15:39:14Z")

</div>

You should provide more information about what you are expecting to see and what you are seeing instead to get a more precise answer.

> [@Please read: make it easier to help you](https://discourse.julialang.org/t/please-read-make-it-easier-to-help-you/14757):
>
> Welcome to the Julia Discourse! We are enthusiastic about helping Julia programmers, both beginner and experienced. This public service announcement (PSA) outlines best practices when asking for help. Following these points makes it easier for us to help you and more likely you’ll get a prompt, useful answer. Keywords are highlighted to make it easier to refer to specific points. Choose a descriptive title that captures the key part of your question, eg “plots with multiple axes” instead of …

I am guessing that recent updates to the XLSX package may use a different syntax than the older version used in the tutorial.

The code below will read your Excel table into a DataFrame and then access the first column.

```julia
using DataFrames, XLSX
G = DataFrame(XLSX.readtable("data/zillow_data_download_april2020.xlsx", "Sale_counts_city"))
first_column = G[:, 1]

```

Resources:  
[https://felipenoris.github.io/XLSX.jl/dev/tutorial/#Read-Tabular-Data](https://felipenoris.github.io/XLSX.jl/dev/tutorial/#Read-Tabular-Data)  
[https://dataframes.juliadata.org/stable/man/working\_with\_dataframes/#Working-with-Data-Frames](https://dataframes.juliadata.org/stable/man/working_with_dataframes/#Working-with-Data-Frames)  
[https://tables.juliadata.org/dev/#Using-the-Interface-(i.e.-consuming-Tables.jl-compatible-sources)](https://tables.juliadata.org/dev/#Using-the-Interface-(i.e.-consuming-Tables.jl-compatible-sources))

---

<div class="post-metadata">

### Author: ![VISHWARATH\_T](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/vishwarath_t/32/49212_2.png) [@VISHWARATH\_T](https://discourse.julialang.org/u/VISHWARATH_T)
#### Post date: [May 9, 2023, 9:05am UTC](https://discourse.julialang.org/t/julia-academy-data-science-tutorial/98483/3 "2023-05-09T09:05:54Z")

</div>

Yes, I will be more clear next time! I thought that there would be a dedicated forum page for the Julia academy tutorials that would give the context of the posts. In its absence, I will make sure I give enough snapshots of the kind of issues I am facing.
