Pandas: How can I merge two dataframes? [closed]
up vote
3
down vote
favorite
1
I found (How do I merge two data frames in Python Pandas?), but do not get the expected result.
I have these two CSV files:
# f1.csv
num ano
76971 1975
76969 1975
76968 1975
76966 1975
76964 1975
76963 1975
76960 1975
and
# f2.csv
num ano dou url
76971 1975 p1 http://exemplo.com/page1
76968 1975 p2 http://exemplo.com/page10
76966 1975 p2 http://exemplo.com/page100
How do I merge these for to get the result given below?
# Expected result
num ano dou url
76971 1975 p1 http://exemplo.com/page1
76969 1975
76968 1975 p2 http://exemplo.com/page10
76966 1975 p2 http://exemplo.com/page100
76964 1975
76963 1975
76960 1975
pandas
edited Nov 17 at 16:10
Stephen Rauch
1,29751129
asked Nov 17 at 10:51
britodfbr
1213
closed as off-topic by Stephen Rauch, Siong Thye Goh, n1k31t4, Sean Owen♦ Nov 18 at 23:28
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question does not appear to be about data science, within the scope defined in the help center." – Stephen Rauch, Siong Thye Goh, n1k31t4, Sean Owen
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
up vote
3
down vote
favorite
1
I found (How do I merge two data frames in Python Pandas?), but do not get the expected result.
I have these two CSV files:
# f1.csv
num ano
76971 1975
76969 1975
76968 1975
76966 1975
76964 1975
76963 1975
76960 1975
and
# f2.csv
num ano dou url
76971 1975 p1 http://exemplo.com/page1
76968 1975 p2 http://exemplo.com/page10
76966 1975 p2 http://exemplo.com/page100
How do I merge these for to get the result given below?
# Expected result
num ano dou url
76971 1975 p1 http://exemplo.com/page1
76969 1975
76968 1975 p2 http://exemplo.com/page10
76966 1975 p2 http://exemplo.com/page100
76964 1975
76963 1975
76960 1975
pandas
edited Nov 17 at 16:10
Stephen Rauch
1,29751129
asked Nov 17 at 10:51
britodfbr
1213
closed as off-topic by Stephen Rauch, Siong Thye Goh, n1k31t4, Sean Owen♦ Nov 18 at 23:28
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question does not appear to be about data science, within the scope defined in the help center." – Stephen Rauch, Siong Thye Goh, n1k31t4, Sean Owen
If this question can be reworded to fit the rules in the help center, please edit the question.
There are many example on StackOverflow
– Aditya
Nov 17 at 13:03
@Aditya, no how i need. And i newer...
– britodfbr
Nov 17 at 13:45
What do you mean by "but not assert expected result"? Can you elaborate?
– Peter Mortensen
Nov 17 at 16:09
Down vote because this is a trivial question. See SO for numerous posts similar to this.
– Jon
Nov 17 at 18:40
add a comment |
up vote
3
down vote
favorite
1
up vote
3
down vote
favorite
1
1
I found (How do I merge two data frames in Python Pandas?), but do not get the expected result.
I have these two CSV files:
# f1.csv
num ano
76971 1975
76969 1975
76968 1975
76966 1975
76964 1975
76963 1975
76960 1975
and
# f2.csv
num ano dou url
76971 1975 p1 http://exemplo.com/page1
76968 1975 p2 http://exemplo.com/page10
76966 1975 p2 http://exemplo.com/page100
How do I merge these for to get the result given below?
# Expected result
num ano dou url
76971 1975 p1 http://exemplo.com/page1
76969 1975
76968 1975 p2 http://exemplo.com/page10
76966 1975 p2 http://exemplo.com/page100
76964 1975
76963 1975
76960 1975
pandas
edited Nov 17 at 16:10
Stephen Rauch
1,29751129
asked Nov 17 at 10:51
britodfbr
1213
I found (How do I merge two data frames in Python Pandas?), but do not get the expected result.
I have these two CSV files:
# f1.csv
num ano
76971 1975
76969 1975
76968 1975
76966 1975
76964 1975
76963 1975
76960 1975
and
# f2.csv
num ano dou url
76971 1975 p1 http://exemplo.com/page1
76968 1975 p2 http://exemplo.com/page10
76966 1975 p2 http://exemplo.com/page100
How do I merge these for to get the result given below?
# Expected result
num ano dou url
76971 1975 p1 http://exemplo.com/page1
76969 1975
76968 1975 p2 http://exemplo.com/page10
76966 1975 p2 http://exemplo.com/page100
76964 1975
76963 1975
76960 1975
pandas
pandas
edited Nov 17 at 16:10
Stephen Rauch
1,29751129
asked Nov 17 at 10:51
britodfbr
1213
edited Nov 17 at 16:10
Stephen Rauch
1,29751129
asked Nov 17 at 10:51
britodfbr
1213
edited Nov 17 at 16:10
Stephen Rauch
1,29751129
edited Nov 17 at 16:10
Stephen Rauch
1,29751129
edited Nov 17 at 16:10
Stephen Rauch
1,29751129
1,29751129
asked Nov 17 at 10:51
britodfbr
1213
asked Nov 17 at 10:51
britodfbr
1213
asked Nov 17 at 10:51
britodfbr
1213
1213
closed as off-topic by Stephen Rauch, Siong Thye Goh, n1k31t4, Sean Owen♦ Nov 18 at 23:28
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question does not appear to be about data science, within the scope defined in the help center." – Stephen Rauch, Siong Thye Goh, n1k31t4, Sean Owen
If this question can be reworded to fit the rules in the help center, please edit the question.
closed as off-topic by Stephen Rauch, Siong Thye Goh, n1k31t4, Sean Owen♦ Nov 18 at 23:28
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This question does not appear to be about data science, within the scope defined in the help center." – Stephen Rauch, Siong Thye Goh, n1k31t4, Sean Owen
If this question can be reworded to fit the rules in the help center, please edit the question.
There are many example on StackOverflow
– Aditya
Nov 17 at 13:03
@Aditya, no how i need. And i newer...
– britodfbr
Nov 17 at 13:45
What do you mean by "but not assert expected result"? Can you elaborate?
– Peter Mortensen
Nov 17 at 16:09
Down vote because this is a trivial question. See SO for numerous posts similar to this.
– Jon
Nov 17 at 18:40
add a comment |
There are many example on StackOverflow
– Aditya
Nov 17 at 13:03
@Aditya, no how i need. And i newer...
– britodfbr
Nov 17 at 13:45
What do you mean by "but not assert expected result"? Can you elaborate?
– Peter Mortensen
Nov 17 at 16:09
Down vote because this is a trivial question. See SO for numerous posts similar to this.
– Jon
Nov 17 at 18:40
There are many example on StackOverflow
– Aditya
Nov 17 at 13:03
There are many example on StackOverflow
– Aditya
Nov 17 at 13:03
@Aditya, no how i need. And i newer...
– britodfbr
Nov 17 at 13:45
@Aditya, no how i need. And i newer...
– britodfbr
Nov 17 at 13:45
What do you mean by "but not assert expected result"? Can you elaborate?
– Peter Mortensen
Nov 17 at 16:09
What do you mean by "but not assert expected result"? Can you elaborate?
– Peter Mortensen
Nov 17 at 16:09
Down vote because this is a trivial question. See SO for numerous posts similar to this.
– Jon
Nov 17 at 18:40
Down vote because this is a trivial question. See SO for numerous posts similar to this.
– Jon
Nov 17 at 18:40
add a comment |
1 Answer
1
active
oldest
votes
up vote
6
down vote
accepted
f1.merge(f2, left_on='num', right_on='num', how='outer')
see https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.merge.html
answered Nov 17 at 12:58
wl1234
763
2
very thanks! I finish below: a1975.merge(b1975, left_on=['num', 'ano'], right_on=['num', 'ano'], how='outer', sort=True)
– britodfbr
Nov 17 at 13:46
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
6
down vote
accepted
f1.merge(f2, left_on='num', right_on='num', how='outer')
see https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.merge.html
answered Nov 17 at 12:58
wl1234
763
2
very thanks! I finish below: a1975.merge(b1975, left_on=['num', 'ano'], right_on=['num', 'ano'], how='outer', sort=True)
– britodfbr
Nov 17 at 13:46
add a comment |
up vote
6
down vote
accepted
f1.merge(f2, left_on='num', right_on='num', how='outer')
see https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.merge.html
answered Nov 17 at 12:58
wl1234
763
2
very thanks! I finish below: a1975.merge(b1975, left_on=['num', 'ano'], right_on=['num', 'ano'], how='outer', sort=True)
– britodfbr
Nov 17 at 13:46
add a comment |
up vote
6
down vote
accepted
up vote
6
down vote
accepted
f1.merge(f2, left_on='num', right_on='num', how='outer')
see https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.merge.html
answered Nov 17 at 12:58
wl1234
763
f1.merge(f2, left_on='num', right_on='num', how='outer')
see https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.merge.html
answered Nov 17 at 12:58
wl1234
763
answered Nov 17 at 12:58
wl1234
763
answered Nov 17 at 12:58
wl1234
763
answered Nov 17 at 12:58
wl1234
763
763
2
very thanks! I finish below: a1975.merge(b1975, left_on=['num', 'ano'], right_on=['num', 'ano'], how='outer', sort=True)
– britodfbr
Nov 17 at 13:46
add a comment |
2
very thanks! I finish below: a1975.merge(b1975, left_on=['num', 'ano'], right_on=['num', 'ano'], how='outer', sort=True)
– britodfbr
Nov 17 at 13:46
2
2
very thanks! I finish below: a1975.merge(b1975, left_on=['num', 'ano'], right_on=['num', 'ano'], how='outer', sort=True)
– britodfbr
Nov 17 at 13:46
very thanks! I finish below: a1975.merge(b1975, left_on=['num', 'ano'], right_on=['num', 'ano'], how='outer', sort=True)
– britodfbr
Nov 17 at 13:46
add a comment |
There are many example on StackOverflow
– Aditya
Nov 17 at 13:03
@Aditya, no how i need. And i newer...
– britodfbr
Nov 17 at 13:45
What do you mean by "but not assert expected result"? Can you elaborate?
– Peter Mortensen
Nov 17 at 16:09
Down vote because this is a trivial question. See SO for numerous posts similar to this.
– Jon
Nov 17 at 18:40