Скачать или смотреть How to Print Only Certain Columns from a DataFrame in Python using pandas

Learn how to filter and print specific columns from a DataFrame in Python, focusing on cases where specific character conditions are involved.
---
This video is based on the question https://stackoverflow.com/q/62609953/ asked by the user 'Aswin Babu' ( https://stackoverflow.com/u/13100796/ ) and on the answer https://stackoverflow.com/a/62609996/ provided by the user 'Rishit Dagli' ( https://stackoverflow.com/u/11878567/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How to print only certain columns from datframe in python after searching for a particular character in the values inside a column

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Print Only Certain Columns from a DataFrame in Python

When working with data in Python, especially using the pandas library, you may find yourself needing to filter rows based on specific conditions and then print only certain columns from those filtered results. This common scenario is essential for data analysis and reporting.

The Problem: Filtering and Selecting Columns

Let's say you have a DataFrame, df, that contains stock market data for Microsoft (MSFT), which looks like this:

Datemsft_closemsft_highsignal01-01-20350358buy02-01-20370377sell03-01-20365370NaN04-01-20368371buyIn this DataFrame:

The signal column indicates buy or sell signals for the stock.

You want to filter the rows where the signal column contains the value "buy" and then output only the msft_close column for those rows.

The initial code to filter the DataFrame looks something like this:

[[See Video to Reveal this Text or Code Snippet]]

However, this will return all columns for the rows where the signal is "buy," and you only want to print the msft_close column along with the corresponding Date.

The Solution: Filtering and Selecting Specific Columns

To achieve the desired output, you can modify your code slightly. You can chain the filtering operation with the column selection. Here's how you'd do it:

[[See Video to Reveal this Text or Code Snippet]]

Breakdown of the Code:

df["signal"].astype(str).str.contains("buy"): This part filters the DataFrame to include only those rows where the signal contains the substring "buy."

["msft_close"]: After filtering, you simply select the msft_close column to display.

Adding the Date Column

While your initial target output included only the msft_close column, if you want to include the corresponding Date column, you can extend the code as follows:

[[See Video to Reveal this Text or Code Snippet]]

Target Output

The final output you'd get would look like this:

Datemsft_close01-01-2035004-01-20368This gives you the exact information you're after, providing clarity on the stock's closing prices for the specified dates where the "buy" signal was present.

Conclusion

Filtering DataFrames and selecting specific columns in Python's pandas library is a straightforward process once you understand the chaining of operations. By utilizing the method shown above, you can easily tailor your DataFrame views to suit your analytical needs.

Now you can efficiently analyze your data, focusing only on the columns that matter most! Happy coding!