Create contour/density plots from imported data?

I do not know how to create more arguments from my import file and I need to create a contour plot and a density plot. Attached is my notebook with the work I have done so far.

Module 2.nb (165 KB)

Hi Leon,

Please attach mystery2.xlsx to your post.

Updated with mystery 2

mystery2_-73182571.xlsx (1.09 MB)

I don’t think ContourPlot is the right way to visualize that data. Try

data = Import["~/Downloads/mystery2_-73182571.xlsx", "Data"] // First;

MatrixPlot[data]

To change the orientation

MatrixPlot[Reverse@data]

I have to make it into a contour plot, is there a way I can convert the file data into a function or another code that has contour plot?

Take a look at ListContourPlot and ListDensityPlot.

I have taken a look at those and I tried, but my arguments do not work. What would you suggest be in the command? Because I tried setting it up like any other plot that involves an import, but it still won’t work.

Hi Leon,

Not sure what you tried, but this should work

data = Import["~/Downloads/mystery2_-73182571.xlsx", "Data"] // First;

ListContourPlot[data]
ListDensityPlot[data]

Did it actually produce a graph for you? Because I didn’t get anything.

“I didn’t get anything” is not helpful, it would be great if you posted the code you tried. What version of Mathematica are you using?

data = Import["~/Downloads/mystery2_-73182571.xlsx", "Data"] // First;
ListContourPlot[data]

I am sorry for the late response. I used the command flatten and that caused my code to fail. Thank you for your help. Also, can you tell me what //First does?