Pandas ValueError Arrays Must be All Same Length

by

you can do this to avoid that error

a = {'Links' : lines ,'Titles' : titles , 'Singers': finalsingers , 'Albums':finalalbums , 'Years' : years}
df = pd.DataFrame.from_dict(a, orient="index")
df = df.transpose()

Explanation:

This creates the DataFrame as each key (e.g. 'Links') was a row and like this the missing values are actually missing columns which is no problem for pandas (only missing rows lead to ValueError during creation) After that you transpose the DataFrame (flip the axis) and make the rows to columns, which results the DataFrame you initially wanted.

More Related Contents:

  1. how to calculation cost time [closed]
  2. String concatenation of two pandas columns
  3. Reshape wide to long in pandas
  4. How do I create test and train samples from one dataframe with pandas?
  5. pandas groupby sort within groups
  6. Applying function with multiple arguments to create a new pandas column
  7. How to create a large pandas dataframe from an sql query without running out of memory?
  8. How do convert a pandas dataframe to XML?
  9. How to add hovering annotations to a plot
  10. Sort a pandas dataframe series by month name
  11. Count frequency of values in pandas DataFrame column
  12. Strip / trim all strings of a dataframe
  13. How to iterate over consecutive chunks of Pandas dataframe efficiently
  14. How to flatten multilevel/nested JSON?
  15. Neural Network LSTM input shape from dataframe
  16. Joining pandas DataFrames by Column names
  17. Get list of pandas dataframe columns based on data type
  18. Diff of two Dataframes
  19. Apply function to pandas DataFrame that can return multiple rows
  20. Write to StringIO object using Pandas Excelwriter?
  21. Scikit Learn OneHotEncoder fit and transform Error: ValueError: X has different shape than during fitting
  22. “Anti-merge” in pandas (Python)
  23. Writing to a file on SFTP server opened using Paramiko/pysftp “open” method is slow
  24. Convert Pandas series containing string to boolean
  25. pandas columns correlation with statistical significance
  26. How to create Pandas groupby plot with subplots
  27. Hierarchic pie/donut chart from Pandas DataFrame using bokeh or matplotlib
  28. How to delete the last row of data of a pandas dataframe
  29. How to Pandas fillna() with mode of column?
  30. Python Pandas: Highlight matching text and row

Leave a Comment