How to compare two csv files by columns?

I have two csv files file1 and file2. I want to compare both csv's by applying condition.
col2, col4 of file1 are equal to col2, col4 of file2 but difference in col6 of file1 and file2
eg: if col2 & col4 of file1 = col2 & col4 of file2 and col6 in file1 != col6 in file2 then get the output based on the condition.

I tried awk but it is not giving me the desired results. I searched a lot on internet and forums but I am out of searches now.
My awk code is

awk 'NR==FNR{a[$2$4]=$2$4;next}{if ($2$4 in a && a[$6] != $6)print;}' FS="," file1.csv file2.csv

There is something wrong in my script. Please help me

Please help me to resolve this issue. Also let me know if we can resolve this using Python

Adapting your own attempt, try

awk 'NR==FNR {a[$2 $4] = $6; next}  a[$2 $4] != $6' FS="," file1 file2