Turn a spreadsheet column header into a snake_case column name: lower-case it, replace any run of non-alphanumeric characters with a single underscore, and strip underscores from both ends ("Order Date (IST)" → "order_date_ist").
Input: header = 'Order Date (IST)' Output: 'order_date_ist'
Input: header = 'Total Sales ₹' Output: 'total_sales'
Return the answer from the function (do not print it). All tests use valid input as described.
Solve it in the live editor on this page — run on sample data, then submit against hidden tests.
{{ totalCount }} questions · {{ shHardPct }}% Hard. Data-analyst Python questions: strings, records, dates, statistics and regex. Write real Python 3 in your browser, run sample tests, then submit against hidden tests.
Guests can solve {{ freeLimit }} problems for free. Log in or sign up (free) to unlock everything, keep your streak and appear on the leaderboard. New to a topic? Learn it first in the Python course.
{{ p.statement }}
{{ p.constraints }}
No submissions yet. Press Submit to judge your code against all tests.
The model solution and step-by-step explanation unlock when you solve this problem or after 3 unsuccessful submissions ({{ shFailsLabel }}). Struggling? Try the hints on the Question tab first.
{{ p.solution }}
Create your free TechTown account to unlock every problem, track your progress, bookmark questions and keep preparing for interviews.