PNP Kumar

[vijpavan]

Dates in output from capital_market.index_data(index='NIFTY 50', from_date="01-03-2024", to_date="01-03-2024").to_csv("datapy.CSV")) are not properly formatted i.e dates 1st to 12th March are appearing in Date format and dates 13th to 15th March are appearing in General format. Pl advise any syntax to get all dates in any one format

	TIMESTAMP	INDEX_NAME	OPEN_INDEX_VAL	HIGH_INDEX_VAL	CLOSE_INDEX_VAL	LOW_INDEX_VAL	TRADED_QTY	TURN_OVER
0	03/01/2024	NIFTY 50	22048.3	22353.3	22338.75	22047.75	3.52E+08	29646.47
1	03/02/2024	NIFTY 50	22406.95	22419.55	22378.4	22367.05	35763814	1918.77
2	03/04/2024	NIFTY 50	22403.5	22440.9	22405.6	22358.3	2.99E+08	23771.71
3	03/05/2024	NIFTY 50	22371.25	22416.9	22356.3	22269.15	2.96E+08	29165.37
4	03/06/2024	NIFTY 50	22327.5	22497.2	22474.05	22224.35	3.12E+08	31029.01
5	03/07/2024	NIFTY 50	22505.3	22525.65	22493.55	22430	3.8E+08	33558.46
6	03/11/2024	NIFTY 50	22517.5	22526.6	22332.65	22307.25	2.78E+08	27222.37
7	03/12/2024	NIFTY 50	22334.45	22452.55	22335.7	22256	2.99E+08	29781.12
8	13-03-2024	NIFTY 50	22432.2	22446.75	21997.7	21905.65	4.93E+08	40109.23
9	14-03-2024	NIFTY 50	21982.55	22204.6	22146.65	21917.5	4.27E+08	37348.3
10	15-03-2024	NIFTY 50	22064.85	22120.9	22023.35	21931.7	6.61E+08	60260.88