List of Tuples to DataFrame Conversion [duplicate]

by

I think this is what you want:

>>> data = [('2013-01-16', 'AAPL', 1),
            ('2013-01-16', 'GOOG', 1.5),
            ('2013-01-17', 'GOOG', 2),
            ('2013-01-17', 'MSFT', 4),
            ('2013-01-18', 'GOOG', 3),
            ('2013-01-18', 'MSFT', 3)]

>>> df = pd.DataFrame(data, columns=['date', 'ticker', 'value'])
>>> df
         date ticker  value
0  2013-01-16   AAPL    1.0
1  2013-01-16   GOOG    1.5
2  2013-01-17   GOOG    2.0
3  2013-01-17   MSFT    4.0
4  2013-01-18   GOOG    3.0
5  2013-01-18   MSFT    3.0

>>> df.pivot('date', 'ticker', 'value')
ticker      AAPL  GOOG  MSFT
date                        
2013-01-16     1   1.5   NaN
2013-01-17   NaN   2.0     4
2013-01-18   NaN   3.0     3

More Related Contents:

  1. Convert a columns of string to list in pandas
  2. Any built-in function in pandas/python which converts a list like data into a list
  3. How to sort a list/tuple of lists/tuples by the element at a given index?
  4. How to merge lists into a list of tuples?
  5. Are tuples more efficient than lists in Python?
  6. How can I split a column of tuples in a Pandas dataframe?
  7. Pandas DataFrame stored list as string: How to convert back to list
  8. a mutable type inside an immutable container
  9. Convert tuple to list and back
  10. How to unzip a list of tuples into individual lists? [duplicate]
  11. Append to a list defined in a tuple – is it a bug? [duplicate]
  12. Merge multiple column values into one column in python pandas
  13. List of tuples to dictionary [duplicate]
  14. How to form tuple column from two columns in Pandas
  15. Explicitly select items from a list or tuple
  16. How to find the maximum value in a list of tuples? [duplicate]
  17. Converting a list of tuples into a dict
  18. Transform “list of tuples” into a flat list or a matrix
  19. How to compare a list of lists/sets in python?
  20. Find an element in a list of tuples
  21. “unstack” a pandas column containing lists into multiple rows [duplicate]
  22. How to convert list of tuples to multiple lists?
  23. Why can’t I use a list as a dict key in python? Exactly what can and cannot be used, and why?
  24. Column of lists, convert list to string as a new column
  25. How does str.startswith really work?
  26. Concatenate elements of a tuple in a list in python [duplicate]
  27. How to use ast.literal_eval in a pandas dataframe and handle exceptions
  28. Filter a list of tuples based on condition
  29. How can I convert this string to list of lists? [duplicate]
  30. Converting string to tuple without splitting characters

Leave a Comment