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

Open

Open

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

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 !!!

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.

Author

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

to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Assignees

No one assigned

Labels

No labels

No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests