Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Use First Column as ID for Meta files #15

Open
miklevin opened this issue Mar 14, 2024 · 1 comment
Open

Use First Column as ID for Meta files #15

miklevin opened this issue Mar 14, 2024 · 1 comment

Comments

@miklevin
Copy link

miklevin commented Mar 14, 2024

Me again. The next pain point I have is always having to rename the first column in a meta file from Full URL (or whatever) to id on the export from the product I use it with. Again, the problem is in quite how large the files are.

It's not reasonable to ask people to load and save files this large in Excel or Google Sheets just to rename the column label. Sometimes I use a Python script to do it, and other times I do it into vim. All of these options are to technical and show-stoppers when I try to walk other people though the process.

I imagine that 99 out of 100 times when someone is loading a meta file, the first column contains the id.

So that's the feature request. If no id column is specified, please assume that column 1 is the id column. That at least gives it a default fallback behavior. From my perspective, it is a very big win for a very light touch. Please and thank you!

In other words, I am frequently doing this:

import pandas as pd
df = pd.read_csv("meta.csv")
df.rename(columns={df.columns[0]: 'id'}, inplace=True)
df.to_csv("meta-colored.csv", index=False)
@kolmakova
Copy link
Collaborator

Agree, reasonable observation. This should not take a lot of time to add so we'll try to add it soon.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants