What is the difference between a pandas Series and a single-column DataFrame?

by

Quoting the Pandas docs

pandas.DataFrame(data=None, index=None, columns=None, dtype=None, copy=False)

Two-dimensional size-mutable, potentially heterogeneous tabular data structure with labeled axes (rows and columns). Arithmetic operations align on both row and column labels. Can be thought of as a dict-like container for Series objects. The primary pandas data structure.

So, the Series is the data structure for a single column of a DataFrame, not only conceptually, but literally, i.e. the data in a DataFrame is actually stored in memory as a collection of Series.

Analogously: We need both lists and matrices, because matrices are built with lists. Single row matricies, while equivalent to lists in functionality still cannot exist without the list(s) they’re composed of.

They both have extremely similar APIs, but you’ll find that DataFrame methods always cater to the possibility that you have more than one column. And, of course, you can always add another Series (or equivalent object) to a DataFrame, while adding a Series to another Series involves creating a DataFrame.

More Related Contents:

  1. how to calculation cost time [closed]
  2. How to add a new column to an existing DataFrame?
  3. Pandas: Adding new column to dataframe which is a copy of the index column
  4. pandas: filter rows of DataFrame with operator chaining
  5. Pandas groupby: How to get a union of strings
  6. How do I create test and train samples from one dataframe with pandas?
  7. pandas groupby sort within groups
  8. Applying function with multiple arguments to create a new pandas column
  9. Python Pandas max value in a group as a new column
  10. Convert columns to string in Pandas
  11. Use pandas.shift() within a group
  12. How to query MultiIndex index columns values in pandas
  13. How to convert column with dtype as object to string in Pandas Dataframe [duplicate]
  14. Python – splitting dataframe into multiple dataframes based on column values and naming them with those values [duplicate]
  15. Remove non-ASCII characters from pandas column
  16. Add multiple empty columns to pandas DataFrame
  17. No numeric types to aggregate – change in groupby() behaviour?
  18. OSError: Initializing from file failed on csv in Pandas
  19. Convert column to row in Python Pandas
  20. Line plot with data points in pandas
  21. Python & Pandas: How to query if a list-type column contains something?
  22. Putting many python pandas dataframes to one excel worksheet
  23. Remove Unnamed columns in pandas dataframe [duplicate]
  24. Pandas: Reading Excel with merged cells
  25. Pandas groupby with categories with redundant nan
  26. Datetime conversion – How to extract the inferred format?
  27. Python numpy: cannot convert datetime64[ns] to datetime64[D] (to use with Numba)
  28. Efficient way to add rows to dataframe
  29. Slicing multiple ranges of columns in Pandas, by list of names
  30. Find names of top-n highest-value columns in each pandas dataframe row

Leave a Comment