<pre><code>import pandas as pd
from io import StringIO
# sample data
df = pd.read_fwf(StringIO("""
Company Intro Categories Headquarters Founded_Date Funding_Stage
Apple xyz Healthcare, Big Data New York 2018 Series A
Apple NaN NaN NaN NaN NaN
Apple NaN NaN NaN NaN NaN
Banana Lier Government Europe 2010 Series B
Pear NaN NaN NaN NaN NaN"""), header=1)
# Create the summary level - assumes repeat data comes first
df_summary = df.groupby("Company").head(1)
# Join the result
df_result = df[['Company']].merge(df_summary, on="Company")
# Company Intro Categories Headquarters Founded_Date Funding_Stage
#0 Apple xyz Healthcare, Big Data New York 2018.0 Series A
#1 Apple xyz Healthcare, Big Data New York 2018.0 Series A
#2 Apple xyz Healthcare, Big Data New York 2018.0 Series A
#3 Banana Lier Government Europe 2010.0 Series B
#4 Pear NaN NaN NaN NaN NaN
</code></pre>