Rather than create 2 temporary dfs you can just pass these as params within a dict using the DataFrame constructor:
pd.DataFrame({'email':sf.index, 'list':sf.values})
There are lots of ways to construct a df, see the docs
Related Posts:
- Convert pandas data frame to series
- How to convert index of a pandas dataframe into a column
- how to sort pandas dataframe from one column
- Renaming column names in Pandas
- How to reset index in a pandas dataframe? [duplicate]
- Delete a column from a Pandas DataFrame
- How to deal with SettingWithCopyWarning in Pandas
- How to deal with SettingWithCopyWarning in Pandas
- Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
- How to iterate over rows in a DataFrame in Pandas
- How to iterate over rows in a DataFrame in Pandas
- Writing a pandas DataFrame to CSV file
- Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
- Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
- Writing a pandas DataFrame to CSV file
- Adding new column to existing DataFrame in Python pandas
- How to change the order of DataFrame columns?
- How to change the order of DataFrame columns?
- Pandas DataFrame Groupby two columns and get counts
- How can I use the apply() function for a single column?
- How to show all columns’ names on a large pandas dataframe?
- How to groupby based on two columns in pandas?
- How to deal with SettingWithCopyWarning in Pandas
- Merging dataframes on index with pandas
- Create a Pandas Dataframe by appending one row at a time
- How to replace NaN values by Zeroes in a column of a Pandas Dataframe?
- ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
- Convert Python dict into a dataframe
- Creating an empty Pandas DataFrame, then filling it?
- How do I select rows from a DataFrame based on column values?
- How do I select rows from a DataFrame based on column values?
- Pandas group-by and sum
- How do I get the row count of a Pandas DataFrame?
- Python pandas groupby aggregate on multiple columns, then pivot
- Convert pandas dataframe to NumPy array
- DataFrame constructor not properly called
- How to iterate over rows in a DataFrame in Pandas
- Pandas group-by and sum
- How do I get the row count of a Pandas DataFrame?
- ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
- ‘DataFrame’ object has no attribute ‘sort’
- ‘DataFrame’ object has no attribute ‘sort’
- Rename Pandas DataFrame Index
- pandas: filter rows of DataFrame with operator chaining
- ‘DataFrame’ object has no attribute ‘sort’
- Pandas, merging two dataframes on multiple columns, and multiplying result
- Convert DataFrame column type from string to datetime, dd/mm/yyyy format
- Get a list from Pandas DataFrame column headers
- What is dtype(‘O’), in pandas?
- How to read a .xlsx file using the pandas Library in iPython?
- Get total of Pandas column
- What is dtype(‘O’), in pandas?
- How to check whether a pandas DataFrame is empty?
- Change column type in pandas
- ValueError: ‘object too deep for desired array’
- Shuffle DataFrame rows
- What does axis in pandas mean?
- How to take column-slices of dataframe in pandas
- Combine two columns of text in pandas dataframe
- Python: pandas merge multiple dataframes
- How to count the NaN values in a column in pandas DataFrame
- Pandas: change data type of Series to String
- Pandas – DataFrame object is not callable
- Convert a Pandas DataFrame to a dictionary
- Create a Pandas Dataframe by appending one row at a time
- Normalize columns of pandas data frame
- Normalize columns of pandas data frame
- Selecting/excluding sets of columns in pandas
- How to filter Pandas dataframe using ‘in’ and ‘not in’ like in SQL
- How to apply a function to two columns of Pandas dataframe
- Pandas DataFrame: replace all values in a column, based on condition
- OSError: Initializing from file failed on csv in Pandas
- Data type conversion error: ValueError: Cannot convert non-finite values (NA or inf) to integer
- Pandas – How to flatten a hierarchical index in columns
- Insert a row to pandas dataframe
- Subtract two columns in dataframe
- How to check if a column exists in Pandas
- Pandas error “Can only use .str accessor with string values”
- How to get a value from a cell of a dataframe?
- Pandas split DataFrame by column value
- Groupby value counts on the dataframe pandas
- Rename specific column(s) in pandas
- Pandas index column title or name
- Coalesce values from 2 columns into a single column in a pandas dataframe
- How to add pandas data to an existing csv file?
- Find the unique values in a column and then sort them
- if else function in pandas dataframe
- Read data (.dat file) with Pandas
- Move column by name to front of table in pandas
- pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
- Pandas dataframe groupby plot
- Got continuous is not supported error in RandomForestRegressor
- Logical operators for Boolean indexing in Pandas
- vectorize conditional assignment in pandas dataframe
- Convert list of dictionaries to a pandas DataFrame
- Compare two columns using pandas
- alueError: ordinal must be >= 1
- how to reset index pandas dataframe after dropna() pandas dataframe
- pandas read_json: “If using all scalar values, you must pass an index”
- Selecting multiple columns in a Pandas dataframe