How to import data from excel file in a mysql containing macro functions using pythonHow do I copy a file in Python?How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?How do I connect to a MySQL Database in Python?How to shrink/purge ibdata1 file in MySQLHow to import CSV file to MySQL tableImporting files from different folderHow do you append to a file in Python?How to remove a key from a Python dictionary?“Large data” work flows using pandasHow to import an SQL file using the command line in MySQL?
SOQL Not Recognizing Field?
Why VGA framebuffer was limited to 64kB window?
What is the actual quality of machine translations?
Preventing employees from either switching to competitors or opening their own business
Are there any important biographies of nobodies?
English word for "product of tinkering"
Why would future John risk sending back a T-800 to save his younger self?
Do simulator games use a realistic trajectory to get into orbit?
Thread Pool C++ Implementation
Project Euler #7 10001st prime in C++
Existence of a pointwise convergent subsequence
Taxi Services at Didcot
What ways have you found to get edits from non-LaTeX users?
Why didn't Voldemort recognize that Dumbledore was affected by his curse?
How to draw this diagram with tikzcd or other packages
What do abbreviations in movie scripts stand for?
Is a lack of character descriptions a problem?
Cycle through MeshStyle directives in ListLinePlot
Why did the Herschel Space Telescope need helium coolant?
Inward extrusion is not working
How to return a security deposit to a tenant
Are there downsides to using std::string as a buffer?
Why is one of Madera Municipal's runways labelled with only "R" on both sides?
SQL counting distinct over partition
How to import data from excel file in a mysql containing macro functions using python
How do I copy a file in Python?How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?How do I connect to a MySQL Database in Python?How to shrink/purge ibdata1 file in MySQLHow to import CSV file to MySQL tableImporting files from different folderHow do you append to a file in Python?How to remove a key from a Python dictionary?“Large data” work flows using pandasHow to import an SQL file using the command line in MySQL?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
First of all I am sorry if there's some thing not clear
All I need I want to create a database as I have an excel file that contains a lot of Columns and these columns contains a lot of rows which contains data
I just need to import all these data to mysql database instead to fill it manually as I have a lot of excel files.So I imagine that there's an easy way to import all these data from excel file to a database using Pythons library like pandas and numpy,xlrd
After this If any updates or fill in excel file it automatically update it in the data base and if any update or fill in database it automatically update to excel file as there's many users will use the excel files
Now I need the enviroments, tools and a tutorial for this case
python mysql excel
asked Mar 24 at 17:00
7arooney7arooney
218
add a comment |
First of all I am sorry if there's some thing not clear
All I need I want to create a database as I have an excel file that contains a lot of Columns and these columns contains a lot of rows which contains data
I just need to import all these data to mysql database instead to fill it manually as I have a lot of excel files.So I imagine that there's an easy way to import all these data from excel file to a database using Pythons library like pandas and numpy,xlrd
After this If any updates or fill in excel file it automatically update it in the data base and if any update or fill in database it automatically update to excel file as there's many users will use the excel files
Now I need the enviroments, tools and a tutorial for this case
python mysql excel
asked Mar 24 at 17:00
7arooney7arooney
218
add a comment |
First of all I am sorry if there's some thing not clear
All I need I want to create a database as I have an excel file that contains a lot of Columns and these columns contains a lot of rows which contains data
I just need to import all these data to mysql database instead to fill it manually as I have a lot of excel files.So I imagine that there's an easy way to import all these data from excel file to a database using Pythons library like pandas and numpy,xlrd
After this If any updates or fill in excel file it automatically update it in the data base and if any update or fill in database it automatically update to excel file as there's many users will use the excel files
Now I need the enviroments, tools and a tutorial for this case
python mysql excel
asked Mar 24 at 17:00
7arooney7arooney
218
First of all I am sorry if there's some thing not clear
All I need I want to create a database as I have an excel file that contains a lot of Columns and these columns contains a lot of rows which contains data
I just need to import all these data to mysql database instead to fill it manually as I have a lot of excel files.So I imagine that there's an easy way to import all these data from excel file to a database using Pythons library like pandas and numpy,xlrd
After this If any updates or fill in excel file it automatically update it in the data base and if any update or fill in database it automatically update to excel file as there's many users will use the excel files
Now I need the enviroments, tools and a tutorial for this case
python mysql excel
python mysql excel
asked Mar 24 at 17:00
7arooney7arooney
218
asked Mar 24 at 17:00
7arooney7arooney
218
asked Mar 24 at 17:00
7arooney7arooney
218
asked Mar 24 at 17:00
7arooney7arooney
218
asked Mar 24 at 17:00
7arooney7arooney
218
218
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
First of all, you need to push all the data to your MySQL database. I'd suggest using Object Relational Mappers, such as SQLAlchemy.
You can parse your excel files with pandas. If you don't work with large amounts of numbers, you don't need numpy for this case.
Also, I'd not recommend you using excel files as your main data source. You can add data directly to MySQL and then dump the whole database in xlsx file (you can use XLSXWriter for this case) only when you need it.
answered Mar 24 at 19:18
DesiignerDesiigner
432112
Thanks a lot for your answer I know now what I can I do after confusion for using many libraries but there's a very important clarification I want to tell you that I want to transfer data from more than one excel file to some thing like a main excel file with a specific format for example I have like 4 excel files such as every excel file have a user and this user add data to his excel file all I need I want to push through this new data to this large or main excel file so pandas library will help me to do this?thanks for your help
– 7arooney
Mar 24 at 20:35
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55326259%2fhow-to-import-data-from-excel-file-in-a-mysql-containing-macro-functions-using-p%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
First of all, you need to push all the data to your MySQL database. I'd suggest using Object Relational Mappers, such as SQLAlchemy.
You can parse your excel files with pandas. If you don't work with large amounts of numbers, you don't need numpy for this case.
Also, I'd not recommend you using excel files as your main data source. You can add data directly to MySQL and then dump the whole database in xlsx file (you can use XLSXWriter for this case) only when you need it.
answered Mar 24 at 19:18
DesiignerDesiigner
432112
Thanks a lot for your answer I know now what I can I do after confusion for using many libraries but there's a very important clarification I want to tell you that I want to transfer data from more than one excel file to some thing like a main excel file with a specific format for example I have like 4 excel files such as every excel file have a user and this user add data to his excel file all I need I want to push through this new data to this large or main excel file so pandas library will help me to do this?thanks for your help
– 7arooney
Mar 24 at 20:35
add a comment |
First of all, you need to push all the data to your MySQL database. I'd suggest using Object Relational Mappers, such as SQLAlchemy.
You can parse your excel files with pandas. If you don't work with large amounts of numbers, you don't need numpy for this case.
Also, I'd not recommend you using excel files as your main data source. You can add data directly to MySQL and then dump the whole database in xlsx file (you can use XLSXWriter for this case) only when you need it.
answered Mar 24 at 19:18
DesiignerDesiigner
432112
Thanks a lot for your answer I know now what I can I do after confusion for using many libraries but there's a very important clarification I want to tell you that I want to transfer data from more than one excel file to some thing like a main excel file with a specific format for example I have like 4 excel files such as every excel file have a user and this user add data to his excel file all I need I want to push through this new data to this large or main excel file so pandas library will help me to do this?thanks for your help
– 7arooney
Mar 24 at 20:35
add a comment |
First of all, you need to push all the data to your MySQL database. I'd suggest using Object Relational Mappers, such as SQLAlchemy.
You can parse your excel files with pandas. If you don't work with large amounts of numbers, you don't need numpy for this case.
Also, I'd not recommend you using excel files as your main data source. You can add data directly to MySQL and then dump the whole database in xlsx file (you can use XLSXWriter for this case) only when you need it.
answered Mar 24 at 19:18
DesiignerDesiigner
432112
First of all, you need to push all the data to your MySQL database. I'd suggest using Object Relational Mappers, such as SQLAlchemy.
You can parse your excel files with pandas. If you don't work with large amounts of numbers, you don't need numpy for this case.
Also, I'd not recommend you using excel files as your main data source. You can add data directly to MySQL and then dump the whole database in xlsx file (you can use XLSXWriter for this case) only when you need it.
answered Mar 24 at 19:18
DesiignerDesiigner
432112
answered Mar 24 at 19:18
DesiignerDesiigner
432112
answered Mar 24 at 19:18
DesiignerDesiigner
432112
answered Mar 24 at 19:18
DesiignerDesiigner
432112
432112
Thanks a lot for your answer I know now what I can I do after confusion for using many libraries but there's a very important clarification I want to tell you that I want to transfer data from more than one excel file to some thing like a main excel file with a specific format for example I have like 4 excel files such as every excel file have a user and this user add data to his excel file all I need I want to push through this new data to this large or main excel file so pandas library will help me to do this?thanks for your help
– 7arooney
Mar 24 at 20:35
add a comment |
Thanks a lot for your answer I know now what I can I do after confusion for using many libraries but there's a very important clarification I want to tell you that I want to transfer data from more than one excel file to some thing like a main excel file with a specific format for example I have like 4 excel files such as every excel file have a user and this user add data to his excel file all I need I want to push through this new data to this large or main excel file so pandas library will help me to do this?thanks for your help
– 7arooney
Mar 24 at 20:35
Thanks a lot for your answer I know now what I can I do after confusion for using many libraries but there's a very important clarification I want to tell you that I want to transfer data from more than one excel file to some thing like a main excel file with a specific format for example I have like 4 excel files such as every excel file have a user and this user add data to his excel file all I need I want to push through this new data to this large or main excel file so pandas library will help me to do this?thanks for your help
– 7arooney
Mar 24 at 20:35
Thanks a lot for your answer I know now what I can I do after confusion for using many libraries but there's a very important clarification I want to tell you that I want to transfer data from more than one excel file to some thing like a main excel file with a specific format for example I have like 4 excel files such as every excel file have a user and this user add data to his excel file all I need I want to push through this new data to this large or main excel file so pandas library will help me to do this?thanks for your help
– 7arooney
Mar 24 at 20:35
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55326259%2fhow-to-import-data-from-excel-file-in-a-mysql-containing-macro-functions-using-p%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
