Merging two different csv with pythonPeriodically executing a scraping script with PythonHow to implement accurate counts or sums when you have different numbers of days of the week?Merging two different models in KerasNeed help in improving accuracy of text classification using Naive Bayes in nltk for movie reviewsWhat to give as predictors to predict future values?rectangular markers in bubble plot (Python)Value error in Merging two different models in kerasMerging dataframes in Pandas is taking a surprisingly long timeTime series data into supervised learning problem Python
How to get a plain text file version of a CP/M .BAS (M-BASIC) program?
Why does nature favour the Laplacian?
In order to check if a field is required or not, is the result of isNillable method sufficient?
What happened to Captain America in Endgame?
How can Republicans who favour free markets, consistently express anger when they don't like the outcome of that choice?
Why does processed meat contain preservatives, while canned fish needs not?
Fizzy, soft, pop and still drinks
a sore throat vs a strep throat vs strep throat
How can I place the product on a social media post better?
A Note on N!
How to reduce LED flash rate (frequency)
How to pronounce 'C++' in Spanish
Is there any limitation with Arduino Nano serial communication distance?
What route did the Hindenburg take when traveling from Germany to the U.S.?
How to verbalise code in Mathematica?
Examples of non trivial equivalence relations , I mean equivalence relations without the expression " same ... as" in their definition?
Pulling the rope with one hand is as heavy as with two hands?
Is there really no use for MD5 anymore?
Rivers without rain
Does Gita support doctrine of eternal cycle of birth and death for evil people?
Meaning of Bloch representation
Critique of timeline aesthetic
A Strange Latex Symbol
How do I deal with a coworker that keeps asking to make small superficial changes to a report, and it is seriously triggering my anxiety?
Merging two different csv with python
Periodically executing a scraping script with PythonHow to implement accurate counts or sums when you have different numbers of days of the week?Merging two different models in KerasNeed help in improving accuracy of text classification using Naive Bayes in nltk for movie reviewsWhat to give as predictors to predict future values?rectangular markers in bubble plot (Python)Value error in Merging two different models in kerasMerging dataframes in Pandas is taking a surprisingly long timeTime series data into supervised learning problem Python
$begingroup$
So I have one csv with 'films' in a database that have a unique ID
movie_title | ID | popularity
spider-man unique ID 4.2
captain marvel unique ID 9.9
Then about every week, I would like to update that popularity with a new one from another list of movies.
New movie list:
movie_title | ID | popularity
spider-man unique ID 5.5
captain marvel unique ID 7.4
How can I merge these two csv and output a new csv with only the value popularity updating? I have other values that also change over the week, but I just did popularity for simplicity. The unique ID must be in the new csv as well not only the changes; because, when I resubmit back to the database that is the only way that it will update with the ID.
The second list does not contain the ID's.
python
edited Apr 7 at 17:29
Ethan
706625
asked Apr 7 at 9:12
william validowilliam valido
42
$endgroup$
add a comment |
$begingroup$
So I have one csv with 'films' in a database that have a unique ID
movie_title | ID | popularity
spider-man unique ID 4.2
captain marvel unique ID 9.9
Then about every week, I would like to update that popularity with a new one from another list of movies.
New movie list:
movie_title | ID | popularity
spider-man unique ID 5.5
captain marvel unique ID 7.4
How can I merge these two csv and output a new csv with only the value popularity updating? I have other values that also change over the week, but I just did popularity for simplicity. The unique ID must be in the new csv as well not only the changes; because, when I resubmit back to the database that is the only way that it will update with the ID.
The second list does not contain the ID's.
python
edited Apr 7 at 17:29
Ethan
706625
asked Apr 7 at 9:12
william validowilliam valido
42
$endgroup$
add a comment |
$begingroup$
So I have one csv with 'films' in a database that have a unique ID
movie_title | ID | popularity
spider-man unique ID 4.2
captain marvel unique ID 9.9
Then about every week, I would like to update that popularity with a new one from another list of movies.
New movie list:
movie_title | ID | popularity
spider-man unique ID 5.5
captain marvel unique ID 7.4
How can I merge these two csv and output a new csv with only the value popularity updating? I have other values that also change over the week, but I just did popularity for simplicity. The unique ID must be in the new csv as well not only the changes; because, when I resubmit back to the database that is the only way that it will update with the ID.
The second list does not contain the ID's.
python
edited Apr 7 at 17:29
Ethan
706625
asked Apr 7 at 9:12
william validowilliam valido
42
$endgroup$
So I have one csv with 'films' in a database that have a unique ID
movie_title | ID | popularity
spider-man unique ID 4.2
captain marvel unique ID 9.9
Then about every week, I would like to update that popularity with a new one from another list of movies.
New movie list:
movie_title | ID | popularity
spider-man unique ID 5.5
captain marvel unique ID 7.4
How can I merge these two csv and output a new csv with only the value popularity updating? I have other values that also change over the week, but I just did popularity for simplicity. The unique ID must be in the new csv as well not only the changes; because, when I resubmit back to the database that is the only way that it will update with the ID.
The second list does not contain the ID's.
python
python
edited Apr 7 at 17:29
Ethan
706625
asked Apr 7 at 9:12
william validowilliam valido
42
edited Apr 7 at 17:29
Ethan
706625
asked Apr 7 at 9:12
william validowilliam valido
42
edited Apr 7 at 17:29
Ethan
706625
edited Apr 7 at 17:29
Ethan
706625
edited Apr 7 at 17:29
Ethan
706625
706625
asked Apr 7 at 9:12
william validowilliam valido
42
asked Apr 7 at 9:12
william validowilliam valido
42
asked Apr 7 at 9:12
william validowilliam valido
42
42
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
$begingroup$
What you need is a pandas.DataFrame.update.
Use pandas.read_csv to read the csv file to a Pandas DataFrame, then do the update. Once you have made the update you can use pandas.DataFrame.to_csv to convert it back to a csv.
answered Apr 7 at 18:36
StevenTheDataGuyStevenTheDataGuy
964
$endgroup$
add a comment |
Your Answer
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
);
);
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%2f48798%2fmerging-two-different-csv-with-python%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
$begingroup$
What you need is a pandas.DataFrame.update.
Use pandas.read_csv to read the csv file to a Pandas DataFrame, then do the update. Once you have made the update you can use pandas.DataFrame.to_csv to convert it back to a csv.
answered Apr 7 at 18:36
StevenTheDataGuyStevenTheDataGuy
964
$endgroup$
add a comment |
$begingroup$
What you need is a pandas.DataFrame.update.
Use pandas.read_csv to read the csv file to a Pandas DataFrame, then do the update. Once you have made the update you can use pandas.DataFrame.to_csv to convert it back to a csv.
answered Apr 7 at 18:36
StevenTheDataGuyStevenTheDataGuy
964
$endgroup$
add a comment |
$begingroup$
What you need is a pandas.DataFrame.update.
Use pandas.read_csv to read the csv file to a Pandas DataFrame, then do the update. Once you have made the update you can use pandas.DataFrame.to_csv to convert it back to a csv.
answered Apr 7 at 18:36
StevenTheDataGuyStevenTheDataGuy
964
$endgroup$
What you need is a pandas.DataFrame.update.
Use pandas.read_csv to read the csv file to a Pandas DataFrame, then do the update. Once you have made the update you can use pandas.DataFrame.to_csv to convert it back to a csv.
answered Apr 7 at 18:36
StevenTheDataGuyStevenTheDataGuy
964
answered Apr 7 at 18:36
StevenTheDataGuyStevenTheDataGuy
964
answered Apr 7 at 18:36
StevenTheDataGuyStevenTheDataGuy
964
answered Apr 7 at 18:36
StevenTheDataGuyStevenTheDataGuy
964
964
add a comment |
add a comment |
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%2f48798%2fmerging-two-different-csv-with-python%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
