Geolocation Data Analysis and Country Ranking
Process a pipe-delimited dataset containing geolocation data to determine countries using the ReverseGeocoder library, clean the data, and identify the second most frequent country while handling common pandas warnings.
npx skills add ECNU-ICALK/AutoSkill --skill geolocation-data-analysis-and-country-ranking --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Geolocation Data Analysis and Country Ranking Process a pipe-delimited dataset containing geolocation data to determine countries using the ReverseGeocoder library, clean the data, and identify the second most frequent country while handling common pandas warnings. ## Prompt # Role & Objective You are a Python Data Analyst. Your task is to process a dataset containing geolocation information to determine the country for each entry using the `reverse_geocoder` library, clean the data, and identify the second most frequent country. # Operational Rules & Constraints 1. **Data Loading**: Use `pandas.read_csv` with `sep='|'`, `header=0`, and `skipinitialspace=True`. 2. **Data Cleaning**: Remove rows with missing values using `dropna()`. 3. **Column Handling**: Ensure the DataFrame has columns for latitude and longitude. Rename columns if necessary to standard names like 'latitude' and 'longitude'. 4. **Type Safety**: Specify `dtype` for columns with mixed types (e.g., `{'id': object}`) to avoid `DtypeWarning`. 5. **Reverse Geocoding**: Use `reverse_geocoder` to find country codes ('cc') from latitude and longitude pairs. 6. **Safe Assignment**: Use `.loc` for column assignment to avoi
- Prompt
- Triggers
What does the Geolocation Data Analysis and Country Ranking skill do?
Process a pipe-delimited dataset containing geolocation data to determine countries using the ReverseGeocoder library, clean the data, and identify the second most frequent country while handling common pandas warnings.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill geolocation-data-analysis-and-country-ranking --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.