Left filefo14JUN2022bhav.csv
Right filefo14JUN2022bhav.csv.modified
Key columnsINSTRUMENT, SYMBOL, EXPIRY_DT, STRIKE_PR, OPTION_TYP
Common non-key columnsOPEN, HIGH, LOW, CLOSE, SETTLE_PR, CONTRACTS, VAL_INLAKH, TIMESTAMP,
Columns only in left file (ignored)OPEN_INT, CHG_IN_OI

Comparison result:

MatchedDiffsOnly in leftOnly in right
64061 rows (93.32% cells)6 rows (0.00% cells)5 rows + 2 columns (6.67% cells)1 rows (0.00% cells)

Only in left

INSTRUMENTSYMBOLEXPIRY_DTSTRIKE_PROPTION_TYPOPENHIGHLOWCLOSESETTLE_PRCONTRACTSVAL_INLAKHTIMESTAMP
FUTIDXMIDCPNIFTY30-Aug-20220XX0006924.756479.750014-JUN-2022
FUTIDXMIDCPNIFTY08-Aug-20220XX0006722.956459.750014-JUN-2022
FUTSTKHDFCAMC28-Jul-20220XX1818.118351808.151828.41828.47203933.1714-JUN-2022
OPTSTKZYDUSLIFE25-Aug-2022390PE00033.744.30014-JUN-2022
OPTSTKZYDUSLIFE25-Aug-2022385PE00030.840.60014-JUN-2022

Only in right

INSTRUMENTSYMBOLEXPIRY_DTSTRIKE_PROPTION_TYPOPENHIGHLOWCLOSESETTLE_PRCONTRACTSVAL_INLAKHTIMESTAMP
FUTIDXBANKNIFTY30-Jun-20220XX3339033701.0533185.1533377.0533377.051635231365831.2114-JUN-2022

Diffs

INSTRUMENTSYMBOLEXPIRY_DTSTRIKE_PROPTION_TYPOPENHIGHLOWCLOSESETTLE_PRCONTRACTSVAL_INLAKHTIMESTAMP
FUTSTKHDFC25-Aug-20220XX21302153.652116.852125.552125.552126.5547300.6314-JUN-2022
OPTIDXBANKNIFTY16-Jun-202234100CE87.68.6147.514747.663.6563.655791524949261.46494261.4614-JUN-2022
OPTIDXBANKNIFTY16-Jun-202234300CE78.6599.859.8531.3540.9540.957151976142670.8114-JUN-2022
OPTSTKZEEL25-Aug-2022295CE00013.958.580014-JUN-2022
OPTSTKZYDUSLIFE25-Aug-2022430PE00061.556.5577.3770014-JUN-2022
OPTSTKZYDUSLIFE25-Aug-2022435PE00065.4581.8810014-JUN-2022