pandas-ai
pandas-ai copied to clipboard
sinaptik-ai
MongoDB Connector for PandasAI
🚀 The feature
Integrate a MongoDB connector into PandasAI to allow users to easily access and manipulate data stored in MongoDB databases. This connector will leverage PyMongoArrow to efficiently convert MongoDB query results into Apache Arrow, Numpy, and Pandas formats, improving performance during data manipulation and analysis.
Motivation, pitch
T simplify the process of accessing and manipulating data stored in MongoDB for PandasAI users. Additionally, by utilizing PyMongoArrow, users will benefit from efficient data conversion between MongoDB and the common data formats used in data analysis, such as Apache Arrow, Numpy, and Pandas.
Alternatives
Additional context
That's a great idea! Do you want to work on this @bsab? How do you think we could handle "nested" schemas?
@gventuri yes, I can work on this feature. About the nested schema, I think we can solve it via pymongoarrow: https://mongo-arrow.readthedocs.io/en/latest/schemas.html
@bsab sounds great, also pymongoarrow seems a great solution for that. Just assigned to you :)
Hello @buddhiraz, I've just create the branch "https://github.com/bsab/pandas-ai/tree/feat/connector/mongodb" and added you as contributor. Feel free to work on it ;)
Sure, I will work on it then.
On Tue, Nov 14, 2023 at 9:11 PM Sab Severino @.***> wrote:
Hello @buddhiraz https://github.com/buddhiraz, I've just create the branch "https://github.com/bsab/pandas-ai/tree/feat/connector/mongodb" and added you as contributor. Feel free to work on it ;)
— Reply to this email directly, view it on GitHub https://github.com/gventuri/pandas-ai/issues/728#issuecomment-1810481821, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALKSCKYCDVCTGPESGXXCNSDYEOGKHAVCNFSM6AAAAAA64VKJ26VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMJQGQ4DCOBSGE . You are receiving this because you were mentioned.Message ID: @.***>
hey @PizBernina, yes I've hust invited you to collaborate on the relative branch.
HI @bsab, I am also working on a similar issue of integrating RediSearch to this. Please let me know how can I start to look into this as I am new to databases connectors. Thanks
Hi @bsab , I think I can help you on this enhancement by adding testcases.
While reading the code, I found that some methods and their functionalities for connectors are same. So I think I can straight away write unit test cases for those methods.
Kindly correct me if my thinking is wrong. Thanks... :)
Hey @mikumifa, I'm really sorry but I'm not able to work on this issue due to time constraints. If you'd like, I can assign it to you. Let me know what you think.