How to compare records from two text files and then print the entire line from both files if match is found in python2019 Community Moderator ElectionPython: Parse and Print Text File Line by LineHow should I read a file line-by-line in Python?How to search and replace text in a file using Python?How to print select lines of a text file in python?How to print names from a text file in PythonHow to print multiple lines from a file pythonReading two columns of numbers from a text file in pythonHow to compare strings of lines from two different files using python?Python way to compare the values from file A and B and if A matches then print Entire line from BPython Pandas: Compare two CSV files and delete lines from both the file by matching a column
Is "history" a male-biased word ("his+story")?
Bash script should only kill those instances of another script's that it has launched
Why would one plane in this picture not have gear down yet?
Is it "Vierergruppe" or "Viergruppe", or is there a distinction?
Fixing conmutation for high voltage switching with power mosfet
Good for you! in Russian
Are tamper resistant receptacles really safer?
How are showroom/display vehicles prepared?
Single word request: Harming the benefactor
Declaring and defining template, and specialising them
Find longest word in a string: are any of these algorithms good?
What is the magic ball of every day?
Signed and unsigned numbers
How can I ensure my trip to the UK will not have to be cancelled because of Brexit?
Is it necessary to separate DC power cables and data cables?
Accepted offer letter, position changed
How strictly should I take "Candidates must be local"?
weren't playing vs didn't play
What's wrong with this bogus proof?
Should I tell my boss the work he did was worthless
Error during using callback start_page_number in lualatex
If I receive an SOS signal, what is the proper response?
Do items de-spawn in Diablo?
Why does liquid water form when we exhale on a mirror?
How to compare records from two text files and then print the entire line from both files if match is found in python
2019 Community Moderator ElectionPython: Parse and Print Text File Line by LineHow should I read a file line-by-line in Python?How to search and replace text in a file using Python?How to print select lines of a text file in python?How to print names from a text file in PythonHow to print multiple lines from a file pythonReading two columns of numbers from a text file in pythonHow to compare strings of lines from two different files using python?Python way to compare the values from file A and B and if A matches then print Entire line from BPython Pandas: Compare two CSV files and delete lines from both the file by matching a column
I have two text files. FIle1 contains:
id int| name varchar(10)
1 |Joey
2 |Monica
3 |Rachel
File 2 conatins:
employeeID int | productID int
1 |344
1 |355
2 |544
I want to print on the console, the records that match the ID from the file1 with the EmployeeID from the File2
1|Joey |1|344
1|Joey |1|355
2|Monica|2|544
I have tried something like this,
with open(file1,'rt') as f1:
with open(file2,'rt') as f2:
for lines in f1:
for line in f2:
lines1=lines.split('|')
v1=lines1[0]
line2=line.strip('n')
v2=line2[0]
if (v1==v2):
content=lines.strip('n')+'|'+str(line)
print(content.strip('n'))
else:
pass
But this just gives output as null. When I remove the headers of both the files, it gives me below output.
1|Joey|1|344
1|Joey|1|355
Somehow the first for loop is not iterating over the all lines.
can someone please help
python-3.x
asked Mar 7 at 2:52
Sowmya KudvaSowmya Kudva
62
add a comment |
I have two text files. FIle1 contains:
id int| name varchar(10)
1 |Joey
2 |Monica
3 |Rachel
File 2 conatins:
employeeID int | productID int
1 |344
1 |355
2 |544
I want to print on the console, the records that match the ID from the file1 with the EmployeeID from the File2
1|Joey |1|344
1|Joey |1|355
2|Monica|2|544
I have tried something like this,
with open(file1,'rt') as f1:
with open(file2,'rt') as f2:
for lines in f1:
for line in f2:
lines1=lines.split('|')
v1=lines1[0]
line2=line.strip('n')
v2=line2[0]
if (v1==v2):
content=lines.strip('n')+'|'+str(line)
print(content.strip('n'))
else:
pass
But this just gives output as null. When I remove the headers of both the files, it gives me below output.
1|Joey|1|344
1|Joey|1|355
Somehow the first for loop is not iterating over the all lines.
can someone please help
python-3.x
asked Mar 7 at 2:52
Sowmya KudvaSowmya Kudva
62
add a comment |
I have two text files. FIle1 contains:
id int| name varchar(10)
1 |Joey
2 |Monica
3 |Rachel
File 2 conatins:
employeeID int | productID int
1 |344
1 |355
2 |544
I want to print on the console, the records that match the ID from the file1 with the EmployeeID from the File2
1|Joey |1|344
1|Joey |1|355
2|Monica|2|544
I have tried something like this,
with open(file1,'rt') as f1:
with open(file2,'rt') as f2:
for lines in f1:
for line in f2:
lines1=lines.split('|')
v1=lines1[0]
line2=line.strip('n')
v2=line2[0]
if (v1==v2):
content=lines.strip('n')+'|'+str(line)
print(content.strip('n'))
else:
pass
But this just gives output as null. When I remove the headers of both the files, it gives me below output.
1|Joey|1|344
1|Joey|1|355
Somehow the first for loop is not iterating over the all lines.
can someone please help
python-3.x
asked Mar 7 at 2:52
Sowmya KudvaSowmya Kudva
62
I have two text files. FIle1 contains:
id int| name varchar(10)
1 |Joey
2 |Monica
3 |Rachel
File 2 conatins:
employeeID int | productID int
1 |344
1 |355
2 |544
I want to print on the console, the records that match the ID from the file1 with the EmployeeID from the File2
1|Joey |1|344
1|Joey |1|355
2|Monica|2|544
I have tried something like this,
with open(file1,'rt') as f1:
with open(file2,'rt') as f2:
for lines in f1:
for line in f2:
lines1=lines.split('|')
v1=lines1[0]
line2=line.strip('n')
v2=line2[0]
if (v1==v2):
content=lines.strip('n')+'|'+str(line)
print(content.strip('n'))
else:
pass
But this just gives output as null. When I remove the headers of both the files, it gives me below output.
1|Joey|1|344
1|Joey|1|355
Somehow the first for loop is not iterating over the all lines.
can someone please help
python-3.x
python-3.x
asked Mar 7 at 2:52
Sowmya KudvaSowmya Kudva
62
asked Mar 7 at 2:52
Sowmya KudvaSowmya Kudva
62
edited Mar 7 at 6:24
Sowmya Kudva
asked Mar 7 at 2:52
Sowmya KudvaSowmya Kudva
62
asked Mar 7 at 2:52
Sowmya KudvaSowmya Kudva
62
asked Mar 7 at 2:52
Sowmya KudvaSowmya Kudva
62
62
add a comment |
add a comment |
0
active
oldest
votes
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%2f55035315%2fhow-to-compare-records-from-two-text-files-and-then-print-the-entire-line-from-b%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
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%2f55035315%2fhow-to-compare-records-from-two-text-files-and-then-print-the-entire-line-from-b%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
