Solved: ValueError if using all scalar values, you must pass an index
FIIsTurnover = {'Category': 'FII', 'Trade Date': '17-Jul-2020', 'Buy Value in Rs.': '4287.52', 'Sell Value in Rs.': '5477.05', 'netValue': -1189.5299999999997} df = pd.DataFrame(FIIsTurnover) Result: ValueError: If using all scalar values, you must pass an index Correct Code: df = pd.DataFrame([FIIsTurnover]) Result: Buy Value in Rs. Category Sell Value in Rs. Trade Date netValue 0 4287.52 FII 5477.05 17-Jul-2020 -1189.53 Note: Data should be like, FIIsTurnover = {'Category': ['FII'], 'Trade Date': ['17-Jul-2020'], 'Buy Value in Rs.': ['4287.52'], 'Sell Value in Rs.': ['5477.05'], 'netValue': ['-1189.5299999999997']} df = pd.DataFrame.from_dict(FIIsTurnover)