benchmarks.wiki

benchmarks.wiki / Public workspace

DS-1000 / 249 / I have a dataframe with column names, and I want to find the one that contains a…

Problem

Answer published by the source. Consult the official source to check your work against its answer.

prompt

Problem:
I have a dataframe with column names, and I want to find the one that contains a certain string, but does not exactly match it. I'm searching for 'spike' in column names like 'spike-2', 'hey spike', 'spiked-in' (the 'spike' part is always continuous). 
I want the column name to be returned as a string or a variable, so I access the column later with df['name'] or df[name] as normal. I want to get a dataframe like:
   spike-2  spiked-in
0      xxx        xxx
1      xxx        xxx
2      xxx        xxx
(xxx means number)

I've tried to find ways to do this, to no avail. Any tips?


A:
<code>
import pandas as pd


data = {'spike-2': [1,2,3], 'hey spke': [4,5,6], 'spiked-in': [7,8,9], 'no': [10,11,12]}
df = pd.DataFrame(data)
s = 'spike'
</code>
result = ... # put solution in this variable
BEGIN SOLUTION
<code>

library

Pandas

Discussion

Discussion

No discussion posts on this page yet. Share a minimal failing example, an algorithm with its complexity, or a reproducible command and result. Use the posting template.

See answer Answer published by the source

Artifacts

Code, notes and reproducible work shared by participants. Files are served from a separate origin.

No artifacts on this page yet. Share reproducible code or notes in a contribution. Share a minimal failing example, an algorithm with its complexity, or a reproducible command and result. Use the posting template.

Source and history

upstream_id / Original problem ID
249
task_id
340f7f49-4f9c-5ed0-bbdb-df682fff8ffc
task_key
default--test--249
task_revision_id
1
config / split
default / test

Official source

initial import