Chapter 01 - Data.ipynb error accessing XLSX.DataTable (G)

[PRCervera]

Error while executing G[1]

MethodError: no method matching getindex(::XLSX.DataTable, ::Int64)

Stacktrace:
[1] top-level scope
@ In[42]:1
or accesing G in with all instructions

Help needed !!!

Thank you !!!

[cr00k]

The output of XLSX.readtable() is no longer a tuple but a class. According to XLSX.jl docs ([https://felipenoris.github.io/XLSX.jl/stable/api/#XLSX.readtable]) one should use this function to create DataFrame with DataFrame.jl, which makes much more sense.

For example:
G = DataFrame(XLSX.readtable("data/zillow_data_download_april2020.xlsx","Sale_counts_city"))

Hope it helps.

[PRCervera]

Thank You !!! It works !!! El dom, 30 abr 2023 a las 22:04, cr00k ***@***.***>) escribió:

…

The output of XLSX.readtable() is no longer a tuple but a class. According to XLSX.jl docs ([ https://felipenoris.github.io/XLSX.jl/stable/api/#XLSX.readtable]) one should use this function to create DataFrame with DataFrame.jl, which makes much more sense. For example: G = DataFrame(XLSX.readtable("data/zillow_data_download_april2020.xlsx","Sale_counts_city")) Hope it helps. — Reply to this email directly, view it on GitHub <#49 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A3ZRCDWFJFW62AOSYCGJP63XD3AVHANCNFSM6AAAAAAVU65MKI> . You are receiving this because you authored the thread.Message ID: ***@***.***>

-- Pedro Rodriguez Cervera * From Raw Data to Action S.L.* web : www.rawdata2action.com phone: +34 690264566