Pandas to_sql insert only some columns The 2019 Stack Overflow Developer Survey Results Are InFinding aggregated information of dataPandas: access fields within field in a DataFrameHow can I read in a .csv file with special characters in it in pandas?How to group identical values and count their frequency in Python?Creating data model out of .csv file using PythonHow to extract all information by using idFormatting categories of data with pandas in PythonHow can I merge 2+ DataFrame objects without duplicating column names?Replacing column values in pandas with specific column with multiple database operation?Merging dataframes in Pandas is taking a surprisingly long time
Is there a symbol for a right arrow with a square in the middle?
Does the shape of a die affect the probability of a number being rolled?
Why is the maximum length of OpenWrt’s root password 8 characters?
If I score a critical hit on an 18 or higher, what are my chances of getting a critical hit if I roll 3d20?
Why hard-Brexiteers don't insist on a hard border to prevent illegal immigration after Brexit?
Why is the Constellation's nose gear so long?
Have you ever entered Singapore using a different passport or name?
slides for 30min~1hr skype tenure track application interview
Apparent duplicates between Haynes service instructions and MOT
How to support a colleague who finds meetings extremely tiring?
Reference request: Oldest number theory books with (unsolved) exercises?
Resizing object distorts it (Illustrator CC 2018)
Protecting Dualbooting Windows from dangerous code (like rm -rf)
How to type this arrow in math mode?
Are there incongruent pythagorean triangles with the same perimeter and same area?
Why can Shazam fly?
Shouldn't "much" here be used instead of "more"?
What is the meaning of Triage in Cybersec world?
"as much details as you can remember"
Is a "Democratic" Oligarchy-Style System Possible?
Button changing it's text & action. Good or terrible?
Right tool to dig six foot holes?
Can a flute soloist sit?
FPGA - DIY Programming
Pandas to_sql insert only some columns
The 2019 Stack Overflow Developer Survey Results Are InFinding aggregated information of dataPandas: access fields within field in a DataFrameHow can I read in a .csv file with special characters in it in pandas?How to group identical values and count their frequency in Python?Creating data model out of .csv file using PythonHow to extract all information by using idFormatting categories of data with pandas in PythonHow can I merge 2+ DataFrame objects without duplicating column names?Replacing column values in pandas with specific column with multiple database operation?Merging dataframes in Pandas is taking a surprisingly long time
$begingroup$
I am new using pandas.
I am asking about how to insert specific columns using to_sql.
This is my explanation.
I have a database with a table datasiswa with columns:
- id: as int, with autoincrement, as primary key
- name: string
- age: string
And I have an excel file with header name and age.
How to use to_sql to insert in fields name and age only, without ids.
python pandas data-science-model
edited 2 hours ago
Pedro Henrique Monforte
398111
asked 4 hours ago
Paijo S KomPaijo S Kom
1
New contributor
Paijo S Kom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
add a comment |
$begingroup$
I am new using pandas.
I am asking about how to insert specific columns using to_sql.
This is my explanation.
I have a database with a table datasiswa with columns:
- id: as int, with autoincrement, as primary key
- name: string
- age: string
And I have an excel file with header name and age.
How to use to_sql to insert in fields name and age only, without ids.
python pandas data-science-model
edited 2 hours ago
Pedro Henrique Monforte
398111
asked 4 hours ago
Paijo S KomPaijo S Kom
1
New contributor
Paijo S Kom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
$begingroup$
Is hiding your entire path really necessary?
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
If I understood correctly, you want to fill a SQL Table entries from a Excel file, and this table should create IDs automatically.
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
@PedroHenriqueMonforte Hide because credential our server, yes i just want insert name and age, whitout ids, because id automatically generate by autoincrement.
$endgroup$
– Paijo S Kom
1 hour ago
add a comment |
$begingroup$
I am new using pandas.
I am asking about how to insert specific columns using to_sql.
This is my explanation.
I have a database with a table datasiswa with columns:
- id: as int, with autoincrement, as primary key
- name: string
- age: string
And I have an excel file with header name and age.
How to use to_sql to insert in fields name and age only, without ids.
python pandas data-science-model
edited 2 hours ago
Pedro Henrique Monforte
398111
asked 4 hours ago
Paijo S KomPaijo S Kom
1
New contributor
Paijo S Kom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
I am new using pandas.
I am asking about how to insert specific columns using to_sql.
This is my explanation.
I have a database with a table datasiswa with columns:
- id: as int, with autoincrement, as primary key
- name: string
- age: string
And I have an excel file with header name and age.
How to use to_sql to insert in fields name and age only, without ids.
python pandas data-science-model
python pandas data-science-model
edited 2 hours ago
Pedro Henrique Monforte
398111
asked 4 hours ago
Paijo S KomPaijo S Kom
1
New contributor
Paijo S Kom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 hours ago
Pedro Henrique Monforte
398111
asked 4 hours ago
Paijo S KomPaijo S Kom
1
New contributor
Paijo S Kom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 hours ago
Pedro Henrique Monforte
398111
edited 2 hours ago
Pedro Henrique Monforte
398111
edited 2 hours ago
Pedro Henrique Monforte
398111
398111
asked 4 hours ago
Paijo S KomPaijo S Kom
1
New contributor
Paijo S Kom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
Paijo S KomPaijo S Kom
1
asked 4 hours ago
Paijo S KomPaijo S Kom
1
1
New contributor
Paijo S Kom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Paijo S Kom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Paijo S Kom is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$begingroup$
Is hiding your entire path really necessary?
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
If I understood correctly, you want to fill a SQL Table entries from a Excel file, and this table should create IDs automatically.
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
@PedroHenriqueMonforte Hide because credential our server, yes i just want insert name and age, whitout ids, because id automatically generate by autoincrement.
$endgroup$
– Paijo S Kom
1 hour ago
add a comment |
$begingroup$
Is hiding your entire path really necessary?
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
If I understood correctly, you want to fill a SQL Table entries from a Excel file, and this table should create IDs automatically.
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
@PedroHenriqueMonforte Hide because credential our server, yes i just want insert name and age, whitout ids, because id automatically generate by autoincrement.
$endgroup$
– Paijo S Kom
1 hour ago
$begingroup$
Is hiding your entire path really necessary?
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
Is hiding your entire path really necessary?
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
If I understood correctly, you want to fill a SQL Table entries from a Excel file, and this table should create IDs automatically.
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
If I understood correctly, you want to fill a SQL Table entries from a Excel file, and this table should create IDs automatically.
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
@PedroHenriqueMonforte Hide because credential our server, yes i just want insert name and age, whitout ids, because id automatically generate by autoincrement.
$endgroup$
– Paijo S Kom
1 hour ago
$begingroup$
@PedroHenriqueMonforte Hide because credential our server, yes i just want insert name and age, whitout ids, because id automatically generate by autoincrement.
$endgroup$
– Paijo S Kom
1 hour ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
return StackExchange.using("mathjaxEditing", function ()
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix)
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
);
);
, "mathjax-editing");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "557"
;
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
);
);
Paijo S Kom is a new contributor. Be nice, and check out our Code of Conduct.
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%2fdatascience.stackexchange.com%2fquestions%2f49084%2fpandas-to-sql-insert-only-some-columns%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Paijo S Kom is a new contributor. Be nice, and check out our Code of Conduct.
Paijo S Kom is a new contributor. Be nice, and check out our Code of Conduct.
Paijo S Kom is a new contributor. Be nice, and check out our Code of Conduct.
Paijo S Kom is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Data Science Stack Exchange!
- 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.
Use MathJax to format equations. MathJax reference.
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%2fdatascience.stackexchange.com%2fquestions%2f49084%2fpandas-to-sql-insert-only-some-columns%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
$begingroup$
Is hiding your entire path really necessary?
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
If I understood correctly, you want to fill a SQL Table entries from a Excel file, and this table should create IDs automatically.
$endgroup$
– Pedro Henrique Monforte
3 hours ago
$begingroup$
@PedroHenriqueMonforte Hide because credential our server, yes i just want insert name and age, whitout ids, because id automatically generate by autoincrement.
$endgroup$
– Paijo S Kom
1 hour ago