python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - csv

How to use python pandas to find a specific string in various rows

I am trying to do my taxes. I have over 2,000 rows of data in a CSV of orders. I am trying to just count and print the rows that contain "CA" so I know the ones I need to pay sales tax on. I...
test-img

Crunchy

python

pandas

csv

Votes: 0

Answers: 2

Latest Answer

You can try this code below: import pandas as pd df = pd.read_csv(r'your csv file path') res = df[(df.apply(lambda s: s.eq('CA').any(), axis=1))] print(res)
test-img

ziying35

web-scraping and pagination with python, csv, beautifulsoup and Pandas

This website https://aviation-safety.net/wikibase/ DB begins from year 1902 to 2022. The code presented here captures some years for misses some as well. The years before 1912 and the year after 202...
test-img

James

python

csv

web-scraping

beautifulsoup

pagination

Votes: 0

Answers: 1

Latest Answer

Lmao, I wrote that code for someone on this site once before. I've edited to work for the missing years here: import requests from bs4 import BeautifulSoup import pandas as pd from datetime import dat...
test-img

childnick

CSV - Split multiple-line cell into multiple cells

I’m currently doing some big data work. I have an issue in a .CSV where I need to split a multiple-line single-celled chunk of text, into individual cells. The below table shows the desired output. ...
test-img

CunnyFunt

python

pandas

dataframe

csv

split

Votes: 0

Answers: 2

Latest Answer

Using your code and linked data change delimeter to a comma like below. import pandas as pd df = pd.read_csv('Inventory.csv', delimiter=',') df["Software"]=df["Software"].str.spli...
test-img

ferdy

Appending chunks of CSV to Database with Pandas

I'm trying to improve some code and stop it throwing a warning/error once it's finished (due to the use of next(iter). I'm essentially creating a database engine, reading in a large CSV file in chunks...
test-img

user14380579

python

pandas

postgresql

csv

Votes: 0

Answers: 1

Latest Answer

The problem here is usage of while(True) loop. Ideally to iterate an iterator, you can use a for loop. Incase you want to use a while loop, then take a look at how to use iterator in while loop. I wou...
test-img

Irfanuddin

Posts

Questions

Blogs

Jobs