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

Clean up df after all ods import #15

Open
jwestw opened this issue Jan 5, 2023 · 0 comments
Open

Clean up df after all ods import #15

jwestw opened this issue Jan 5, 2023 · 0 comments

Comments

@jwestw
Copy link
Collaborator

jwestw commented Jan 5, 2023

After importing all the ODS files and concatinating them, there are quite a lot of columns. We need to work out what to do with these.

In one case, the sampling_point was found to be the same data as retail_outlet, so when one was populated the other was empty. This has been fixed.

But there are other mostly empty column(s), like packer_/_manufacturer_/_importer which might be the same data as another column, like the previous example.

These columns need to be investigated and tidied up by combination or deletion.

  • 'packer_/_manufacturer'
  • 'product', 'packer_/manufacturer/_importer'
  • 'address_postcode'
  • 'packer__postcode'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant