Assuming that your dataframe has n rows and n+1 columns (note that the code you posted gives a 6x6 DataFrame, but your screenshot suggests 5x6), you can do:
using LinearAlgebra
scatter(diag(Matrix(asdf[:, 1:end-1])), asdf[!, end])
This will create a square matrix from the first n columns and take the diagonal to create the x vector and then take the last column as the y vector.