1

this is a very basic question, but I am trying to clean up some data for my group, and am trying to just imply import the .accdb file into a data frame format so that I can actually see what I'm dealing with. Can anyone help with this? I also have the series of .txt files that the .accdb file is composed of if that would be easier to import into dataframes individually

Improve this question
7
  • The text files may be easier. Look into using pandas Commented Dec 9, 2019 at 2:15
  • Does this answer your question? Pulling MS access tables and putting them in data frames in python Commented Dec 9, 2019 at 2:19
  • "I wouldn't start from there". Do you have any other non-Access data sources you can use instead? Commented Dec 9, 2019 at 3:04
  • @Chris I have the .txt files that comprise the .accdb file, and I believe I can just import them into a DF using pandas if I’m not mistaken? Would this be the better route Commented Dec 9, 2019 at 12:38
  • Without actually seeing the full dataset it's hard to say what's "better", but text files (assuming they're formatted decently, e.g. as CSV or JSON) are usually nicer to work with than closed binary database formats. Commented Dec 9, 2019 at 13:15
Related questions
0
Importing data with Pandas
15
How do I import an .accdb file into Python and use the data?
7
Python cannot import DataFrame
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.