# PyCall deprecation warning - getindex o.x vs o\[x\] where x is a julia variable
**URL:** https://discourse.julialang.org/t/pycall-deprecation-warning-getindex-o-x-vs-o-x-where-x-is-a-julia-variable/125495
**Category:** General Usage
**Tags:** pycall
**Created:** [February 3, 2025, 12:40pm UTC](https://discourse.julialang.org/t/pycall-deprecation-warning-getindex-o-x-vs-o-x-where-x-is-a-julia-variable/125495 "2025-02-03T12:40:10Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@bernhard](https://discourse.julialang.org/u/bernhard)
#### Post date: [February 3, 2025, 12:40pm UTC](https://discourse.julialang.org/t/pycall-deprecation-warning-getindex-o-x-vs-o-x-where-x-is-a-julia-variable/125495/1 "2025-02-03T12:40:10Z")
All
I get the following deprecation warning
```julia
Warning: `getindex(o::PyObject, s::AbstractString)` is deprecated in favor of dot overloading (`getproperty`) so elements should now be accessed as e.g. `o."s"` instead of `o["s"]`.
│ caller = addChartToWorkbook!(workbook::PyCall.PyObject, worksheet::PyCall.PyObject, chartDict::Dict{AbstractString, Dict{AbstractString, Any}}, location::String) at charts.jl:61
```
it relates to the second last line of this code snippet.
I don’t know how to fix this as in my case the key `s` is a variable in my julia code.
Any ideas?
```julia
function addChartToWorkbook!(workbook::PyCall.PyObject, worksheet::PyCall.PyObject, chartDict::Dict{AbstractString,Dict{AbstractString,Any}}, location::AbstractString) # ;properties=["set_x_axis", "set_y_axis","set_legend"])
chart = PyCall.pycall(workbook."add_chart", PyCall.PyAny, chartDict["add_chart"])
stopboolean = true
i = 1
local thiskey
while stopboolean
thiskey = string("series", i)
if haskey(chartDict, thiskey)
PyCall.pycall(chart."add_series", PyCall.PyAny, chartDict[thiskey])
else
stopboolean = false
break # if there is no series2 then we assume there is no series 3 to n either
end
i += 1
end
# check if this is a combined chart
thiskey = "combChart"
i2 = 1
stopboolean = true
if haskey(chartDict, thiskey)
second_chart = PyCall.pycall(workbook."add_chart", PyCall.PyAny, chartDict[thiskey])
while stopboolean
thiskey = string("series_comb", i2)
if haskey(chartDict, thiskey)
PyCall.pycall(second_chart."add_series", PyCall.PyAny, chartDict[thiskey])
else
stopboolean = false
break # if there is no series2 then we assume there is no series 3 to n either
end
i2 += 1
end
# combine the charts
PyCall.pycall(chart."combine", PyCall.PyAny, second_chart)
end
# set other properties
for x in keys(chartDict)
fieldsWhichAreAlreadySet = [convert(String, string("series", zz)) for zz in 1:i]
resevedKeywords = ["combChart","series_comb1","series_comb2","series_comb3", "series_comb4"] # currently limited to 1+4 series for combined charts
append!(fieldsWhichAreAlreadySet, ["add_series","add_chart"])
append!(fieldsWhichAreAlreadySet, resevedKeywords)
if !in(x, fieldsWhichAreAlreadySet)
PyCall.pycall(chart[x], PyCall.PyAny, chartDict[x]) # TBD: unclear how to fix this line... (deprecated syntax...)
end
end
PyCall.pycall(worksheet."insert_chart", PyCall.PyAny, location, chart)
end
```
---
### Author:  [@stevengj](https://discourse.julialang.org/u/stevengj)
#### Post date: [February 3, 2025, 12:55pm UTC](https://discourse.julialang.org/t/pycall-deprecation-warning-getindex-o-x-vs-o-x-where-x-is-a-julia-variable/125495/2 "2025-02-03T12:55:16Z")
> [@bernhard](#):
>
> ```julia
> if !in(x, fieldsWhichAreAlreadySet)
> PyCall.pycall(chart[x], PyCall.PyAny, chartDict[x]) # TBD: unclear how to fix this line... (deprecated syntax...)
> end
>
> ```
If it’s a field of the object, i.e. you want it to correspond to `chart.x` in Python, do `getproperty(chart, x)`.
If it’s an index of a container, i.e. you want it to correspond to `chart[x]` in Python, do `get(chart, x)`.
---
### Author:  [@bernhard](https://discourse.julialang.org/u/bernhard)
#### Post date: [February 3, 2025, 1:08pm UTC](https://discourse.julialang.org/t/pycall-deprecation-warning-getindex-o-x-vs-o-x-where-x-is-a-julia-variable/125495/3 "2025-02-03T13:08:09Z")
Thank you @stevengj
Unfortunately neither seems to work.
As I have two calls to `chart[x]` in the same line, I even tried the two combinations (once get and once getproperty).
Maybe it is an issue with the underlying pandas function.
I think I am using [pandas.ExcelWriter — pandas 2.2.3 documentation](https://pandas.pydata.org/docs/reference/api/pandas.ExcelWriter.html) (I have not used my code snippet for a while)
If you have time to look at my example code.
Here is an ‘MWE’ (you can run the first 150 rows of the file “1.frenchMTPLdata\_single\_tree.jl”)
[resultingFiles, resM = dtm(dtmtable, sett)](https://github.com/kafisatz/DecisionTrees.jl/blob/0ad12b02f36b724aee0b0c9ddd7d34238a43cf70/tutorials/1.frenchMTPLdata_single_tree.jl#L150)
the error I am getting is
```julia
C:\Users\BERNHA~1.KOE\AppData\Local\Temp\jl_E6216n\dtmresult.xlsx
ePyCallWriteExcel = PyError ($(Expr(:escape, :(ccall(#= C:\Users\bernhard.koenig\.julia\packages\PyCall\1gn3u\src\PyCall.jl:783 =# @pysym(:PyObject_GetItem), PyPtr, (PyPtr, PyPtr), o, PyObject(k))))))
TypeError("'ChartColumn' object is not subscriptable")
PyCall.PyError
msg: String "\$(Expr(:escape, :(ccall(#= C:\\Users\\bernhard.koenig\\.julia\\packages\\PyCall\\1gn3u\\src\\PyCall.jl:783 =# @pysym(:PyObject_GetItem), PyPtr, (PyPtr, PyPtr), o, PyObject(k)))))"
T: PyCall.PyObject
o: Ptr{PyCall.PyObject_struct} @0x00007ffd23e85ea0
val: PyCall.PyObject
o: Ptr{PyCall.PyObject_struct} @0x0000020038718640
traceback: PyCall.PyObject
o: Ptr{PyCall.PyObject_struct} @0x0000000000000000
```
---
### Author:  [@stevengj](https://discourse.julialang.org/u/stevengj)
#### Post date: [February 3, 2025, 1:34pm UTC](https://discourse.julialang.org/t/pycall-deprecation-warning-getindex-o-x-vs-o-x-where-x-is-a-julia-variable/125495/4 "2025-02-03T13:34:34Z")
Can you give a working example in Python? Once you know how to write it in Python, it’s easier to translate to Julia.
PS. Give a _minimal_ example. Load one object and do the indexing/subscript operation you want. Get rid of all the other chart stuff.
PPS. Don’t post screenshots of code, please. They are not searchable, not copy-pasteable, and are counter-productive overall.
---
### Author:  [@bernhard](https://discourse.julialang.org/u/bernhard)
#### Post date: [February 4, 2025, 10:53am UTC](https://discourse.julialang.org/t/pycall-deprecation-warning-getindex-o-x-vs-o-x-where-x-is-a-julia-variable/125495/5 "2025-02-04T10:53:49Z")
thank you.
I have a Julia MWE now (as my Python skills are limited)
But **the depreciation warning is not thrown anymore** (why?)
So I guess my original question is somewhat moot now.
as you can see below `chart[x]` is used
```julia
#using DecisionTrees
using PyCall
using DataFrames
statsfile = joinpath(mktempdir(),"abc.xlsx")
#statsfile = raw"C:\temp\8.xlsx"
function me(statsfile)
data = DataFrame(x=collect(1:13), y=collect(1:13).*2)
@assert isdir(splitdir(statsfile)[1])
isfile(statsfile) && rm(statsfile)
pyModPandas = PyCall.pyimport_conda("pandas", "pandas")
writer = pyModPandas.ExcelWriter(statsfile, engine="xlsxwriter")
sheet = "sheet1"
# create python dataframe
dataDict = Dict("x" => data.x,"y"=>data.y)
pyDF = PyCall.pycall(pyModPandas.DataFrame, PyCall.PyObject, dataDict, columns=propertynames(data))
PyCall.pycall(pyDF."to_excel", PyCall.PyAny, writer, header=false, index=false, sheet_name=sheet, startrow=1, startcol=1)
#writer.close()
chartDict = Dict(
"set_y_axis" => Dict("name"=>"Observed Ratio", "major_gridlines"=>Dict{Any, Any}("visible"=>true)),
"set_legend" => Dict("position"=>"right"),
"set_size" => Dict("y_scale"=>1.5, "x_scale"=>2.4),
"series1" => Dict("name"=>"=sheet1!\$B\$2", "values"=>"=sheet1!\$B\$3:\$B\$10", "categories"=>"=sheet1!\$C\$3:\$C\$10"),
"add_chart" => Dict("type"=>"column"),
"set_title" => Dict("name"=>"Observed Ratio per Segment")
)
workbook = writer.book
#crt = Chart("sheet1",chartDict,"D1")
#writer.close()
chart = PyCall.pycall(workbook."add_chart", PyCall.PyAny, chartDict["add_chart"])
PyCall.pycall(chart."add_series", PyCall.PyAny, chartDict["series1"])
# set other properties
for x in ["set_y_axis","set_legend","set_size","set_title"]
PyCall.pycall(chart[x], PyCall.PyAny, chartDict[x]) # TBD: unclear how to fix this line... (deprecated syntax...)
end
worksheet = writer.sheets["sheet1"]
PyCall.pycall(worksheet."insert_chart", PyCall.PyAny, "D1", chart)
writer.close()
@show statsfile
return nothing
end
me(statsfile)
```