为何df2未显示所有列数据？且仅展示列名不显示列数据的技术咨询

Hey there, let’s dig into why your DataFrame df2 is misbehaving—either hiding some columns entirely or only showing column names with no actual data rows. I’ve tackled these exact headaches before, so here’s a step-by-step breakdown of possible causes and fixes:

Issue 1: df2 isn’t displaying all columns #

If you know the columns exist but they’re getting cut off in the output, this is almost always a Pandas display setting limitation. Here’s how to fix it:

• Adjust Pandas display options: By default, Pandas limits the number of columns shown to keep output readable. Override this with:

  import pandas as pd
  # Show all columns regardless of count
  pd.set_option('display.max_columns', None)
  # Ensure wide columns don't get wrapped/truncated
  pd.set_option('display.width', None)
  

• Verify columns exist first: Before tweaking settings, confirm all columns are actually present in df2 using:

  # List all column names
  print(df2.columns.tolist())
  # Get a high-level overview of the DataFrame
  df2.info()
  

  If the columns show up here but not in the full print, the display settings were definitely the culprit.

Issue 2: df2 only shows column names, no data rows #

This means your DataFrame has columns but zero rows of data. Let’s track down why:

• Data loading failure: If you loaded df2 from a file (CSV, Excel, etc.), double-check:
  • The file path is correct (typos happen!)
  • The file isn’t empty (open it manually to confirm there are data rows below the header)
  • Read parameters match the file format (e.g., using sep=';' for a CSV that uses commas will mess up parsing)
    Quick check to confirm emptiness:

  # (rows, columns) - if rows = 0, it's empty
  print(df2.shape)
  # Direct boolean check for empty DataFrame
  print(df2.empty)
  

• Overly restrictive filtering: If you filtered df2 (e.g., df2 = df2[df2['value'] > 1000]), your condition might not match any rows. Test by removing the filter and checking the raw data first.
• Empty DataFrame creation: If you manually created df2, you might have only defined columns without passing data. For example:

  # This creates an empty DataFrame with only headers
  df2 = pd.DataFrame(columns=['col1', 'col2', 'col3'])
  # Fix by passing actual data
  data = [['a', 1, 2], ['b', 3, 4]]
  df2 = pd.DataFrame(data, columns=['col1', 'col2', 'col3'])
  

Quick Pro Tip #

Start with df2.info()—it’ll instantly tell you how many non-null values are in each column, the total row count, and data types, which is the fastest way to narrow down the problem.

内容的提问来源于stack exchange，提问作者Hassan720