Exporting data from python into excel

[Zankawah]

Dear Sir,
I have interpolated data in python and I want to export the data into excel. The code for the interpolation is pasted below.
The output has been produced by thus code but I tried to export it into excel using

interpolated = upsampled.interpolate(method='linear')
interpolated.head(159)
interpolated.to_excel('test.xlsx')

This code did not produce an error message indicating that the instruction might be successful. However, there is no indication anywhere in the file explorer where the data file in excel could be located. Can anyone offer an idea on how to locate the data file anywhere on the computer in excel, or whether this code is correct.
Thank you

[buran]

the excel should be in the current working directory. You can always supply full path to excel file, so that you be certain where to expect the file.
Note that interpolated.head(159) is doing nothing visible - you don't print it or anything else

[Zankawah]

Thank you for the reply. How do I supply a full path to the excel file? You also indicated that the excel should be in the current working directory but it doesn't show anywhere in the directory. Can you give any guidance on this as well please?
Thank you

[bowlofred]

Just create a full path name instead of the final component. Instead of "test.xlsx", try r"C:\test.xlsx". or r"C:\Users\my_username\test.xlsx".

[Zankawah]

Thank you for the reply. I have tried one of the options you suggested to create a full path as
interpolated.to_excel(r"C:\test.xlsx") but I am still getting error messages. I am not sure if there is something that I am not doing right.
Thank you

[buran]

but I am still getting error messages

You were not getting error messages before, right? What is it? Post full traceback in error tags also post the full code that produce it