Iterates over a big list of .mp3 links to get the metadata tags and save it to an Excel file. Results in this error. I appreciate any help. Thanks.
#print is_connected(); # Create a Pandas dataframe from the data. df = pd.DataFrame({'Links' : lines ,'Titles' : titles , 'Singers': finalsingers , 'Albums':finalalbums , 'Years' : years}) # Create a Pandas Excel writer using XlsxWriter as the engine. writer = pd.ExcelWriter(xlspath, engine='xlsxwriter') # Convert the dataframe to an XlsxWriter Excel object. df.to_excel(writer, sheet_name='Sheet1') #df.to_excel(writer, sheet_name='Sheet1') # Close the Pandas Excel writer and output the Excel file. writer.save() Traceback (most recent call last): File "mp.py", line 87, in <module> df = pd.DataFrame({'Links' : lines ,'Titles' : titles , 'Singers': finalsingers , 'Albums':finalalbums , 'Years' : years}) File "C:\Python27\lib\site-packages\pandas\core\frame.py", line 266, in __init__ mgr = self._init_dict(data, index, columns, dtype=dtype) File "C:\Python27\lib\site-packages\pandas\core\frame.py", line 402, in _init_dict return _arrays_to_mgr(arrays, data_names, index, columns, dtype=dtype) File "C:\Python27\lib\site-packages\pandas\core\frame.py", line 5409, in _arrays_to_mgr index = extract_index(arrays) File "C:\Python27\lib\site-packages\pandas\core\frame.py", line 5457, in extract_index raise ValueError('arrays must all be same length') ValueError: arrays must all be same length