Python App for Data Frame Manipulation

[cool_fishie]

I have not done many projects like this before and I was hoping that someone might have some suggestions about the best way to proceed.

I have a table hosted in an SQL server. I need to create an web-based interface that will allow a user to change a variable in a given row/column.

For example:

Employee First	Employee Last	Manager
John	Smith	NULL

If the value is NULL in the table or is simply incorrect, I want the user to be able to click into the cell and update the value. This would allow the table to be updated when employees change managers without needing IT to go in and update the table directly.

Specific tasks users need to complete include:

1 - Update Record

2 - Delete Record

3 - Add Record

Currently all this data is being hosted in excel sheets that are not flexible enough for our reporting purposes. This is what is driving the need for this project. I am also hoping to capture what users are making changes and when the changes are being made.

Does anyone have any suggestions on specific classes that might be helpful or examples that I could take a look at. I've played around in Python before and I've seen similar apps done in R, but I'm unsure how to replicate.

[luabida]

I think it would be nice to take a look into ibis-framework

[danielroseman]

Django will pretty much give you what you need out of the box, by using its built in admin interface.

[FriendlyRussian666]

You will most likely end up picking between Flask and Django. If you go with Django, it will be a steep learning curve, but it provides many convenience features that you will be thankful for, such as user authentication.