w3docs logo
  1. Snippets
    2. ›
  2. dataframe

How-to articles, tricks, and solutions about DATAFRAME

Change column type in pandas

In pandas, you can change the data type of a column using the astype() function.

python casting types pandas dataframe

Combine two columns of text in pandas dataframe

In pandas, you can use the str.cat() function to combine the values of two columns of text into a single column.

python pandas dataframe

Constructing pandas DataFrame from values in variables gives ValueError

Here is an example code snippet that demonstrates the issue:

python pandas dataframe scalar

Convert floats to ints in Pandas?

To convert floats to integers in Pandas, you can use the astype() function.

integer python floating-point pandas dataframe

Convert list of dictionaries to a pandas DataFrame

Here is an example of how to convert a list of dictionaries to a pandas DataFrame:

python dictionary pandas dataframe

Convert pandas dataframe to NumPy array

In pandas, you can convert a DataFrame to a NumPy array by using the values attribute.

python arrays pandas dataframe numpy

Convert Python dict into a dataframe

You can use the Pandas library to convert a Python dictionary into a dataframe.

python pandas dataframe

Converting a Pandas GroupBy output from Series to DataFrame

Here is an example code snippet that demonstrates how to convert the output of a Pandas GroupBy operation from a Series to a DataFrame:

python pandas dataframe pandas-groupby multi-index

Create a Pandas Dataframe by appending one row at a time

Here is an example of creating a Pandas DataFrame by appending one row at a time:

python append pandas dataframe

Creating an empty Pandas DataFrame, and then filling it

Note that in above example, the DataFrame is created empty first, and then columns are added one by one using the assignment operator (=).

python pandas dataframe