All Questions
Tagged with mysql-python web-scraping
9 questions
2
votes
2
answers
1k
views
Beautiful Soup, get_text but NOT the <span> text.. How can i get it?
Given this markup:
[MARKUP][1]
I need to get the number 182 in a column and the 58 in another. I already have the span, but when I call the div.get_tex() or string it returns = 18258(both numbers)
...
- 41
0
votes
2
answers
1k
views
How to Update and/or insert to MySQL DB using SQLAlchemy from Python List
I am building a webscrape that will run over and over that will insert new data or update data based on ID. if 'id' == 'id': My goal is to avoid duplicates. MySQL table is ready and built. What is ...
- 31
0
votes
0
answers
101
views
How to get the scraped data shown in the MySQL database in the terminal?
I'm trying to get the scraped data to show up in the MySQL database.I'm following a course but it's not working.
I made sure that the data (title, rating, upc, product_type) are in the same order as ...
- 33
0
votes
0
answers
386
views
no module name MySQLdb
I'm doing web scraping (I'm using miniconda) and I need to import the data that I got it using scrapy to a Mysql database but when I execute my program in Python 2.7 using Scrapy it says:
no module ...
- 159
0
votes
1
answer
52
views
Why my mysqldb code is not working? No error message, no data
I wrote a web-scraping script what I save into an excel file and after upload this excel file to my MySQL DB server. I haven't got any error message, but the table is empty in the MySQL. Why? What am ...
- 151
0
votes
1
answer
31
views
Can i use a variante as name for create a new table in MYSQLdb?
I have got this html source :
<div id="ceg">
<span class="cegnev">THE_NAME</span><br>
<span class="cim">XXX</span><br>
YYY </div&...
- 233
0
votes
1
answer
878
views
Unexpected end of regular expression using python
I am trying to scrape stock prices from Yahoo! Finance into a local database as per a tutorial by Chris Reeves, and I keep getting the above error when trying to execute this code. Can anyone tell me ...
- 3
1
vote
1
answer
1k
views
Scrapy and MySQLdb
I'm using Python 2.7 on Mac OS X Lion 10.7.5.
I originally had an issue with installing MySQLdb using both pip-2.7 install MySQL-python as well as downloading and then running python2.7 setup.py ...
- 1,452
0
votes
2
answers
184
views
Pipeline.py showing exception
I am building a small project in Scrapy and am new to Scrapy.
When I am running my spider, it shows an exception error in my pipeline which says:
item['Number'][0], exceptions.IndexError: list index ...
- 45