#read data with two delimiters data = pd.read_csv('data.txt', sep=";|:|,", header=None, engine='python')