w3docs logo
  1. Snippets
    2. ›
  2. pandas

How-to articles, tricks, and solutions about PANDAS

"Large data" workflows using pandas

Here is an example of a workflow for handling large data using the pandas library:

python pandas mongodb hdf5 large-data

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 columns to string in Pandas

To convert all columns in a Pandas DataFrame to strings, you can use the following code snippet:

string python type-conversion pandas

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 Column to DateTime

To convert a column in a Pandas DataFrame to a datetime data type, you can use the pandas.to_datetime() function.

datetime python pandas

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