57370

What is the best way to pass data into pycharm?

Question:

I uploaded data into MySQL and from there am using PyCharm and the plotly.offline library to pass in that data. My end goal is to create a scatter plot of the US with information on places of a certain latitude and longitude.

This is what I am trying to pass in:

checkin_data = pd.read_sql('select bus.business_id, bus.latitude, bus.longitude, sum(chk.checkin_count ) as checkin_count from yelp.business bus inner join yelp.checkin chk ON bus.business_id=chk.business_id group by bus.business_id, bus.latitude, bus.longitude order by bus.business_id limit 10;', con=connection)

I have limited the amount of rows to pass to just 10.

My question is how would I pass in all 10 rows to analyze? I am able to pass in the first one but I do not know how to pass in the rest so that I have a scatter plot with 10 points on the US.

Thank you very much.

Answer1:

What is "analyze"? The SELECT will return 10 rows of several columns each.

This will probably run faster:

select bus.business_id, bus.latitude, bus.longitude, ( SELECT sum(checkin_count) FROM yelp.checkin WHERE business_id = chk.business ) AS checkin_count from yelp.business bus order by bus.business_id limit 10;

Recommend

  • Dummy Variable by date.
  • Django unit testing: South-migrated DB works in MySQL, throws duplicate PK error in PostGreSQL. Am I
  • How does pointer incrementation work?
  • Losing asp.net session in popup. Only in IE and only for some users
  • jinja2 form render does not allow attribute which contains “-”
  • How do I load an Elliptic Curve PEM encoded Private Key? [duplicate]
  • Lodash - Search Nested Array and Return Object
  • Can i use xslt to display drop down menu
  • Python Raspberry pi - If path doesn't exist, skip the loop
  • Android AWS S3 SDK TransferUtility Not Working in Service
  • Error: Aesthetics must be either length 1 or the same as the data (4)
  • PageSize not working on Grid in ExtJS
  • How to restrict template functor return and parameter types
  • Parse weird bug in Swift that causes ACL write permissions to change to an objectId
  • R ggplot2 combining geom_tile and coord_map(“moll”)
  • Javascript : access return of other function
  • Django Template inheritance causes a bus error
  • select query and count based on condition
  • What is the fastest way to select nearest geographical place from mysql database?
  • MassTransit: Adding Headers to Publish Pipeline
  • Tokenize python source code examples (in Python)
  • How do you open .txt file containing matrix in Matlab?
  • How to filter on year and quarter in pandas
  • custom string delimiters stringtemplate-4
  • Color time-series based on column values in pandas
  • Insertion large number of Entities into SQL Server 2012 [duplicate]
  • Google map in top corner left
  • SQL - Select lowest values with group by and order by?
  • R convert summary result (statistics with all dataframe columns) into dataframe
  • Approximate Order-Preserving Huffman Code
  • Intel-64 and ia32 atomic operations acquire-release semantics and GCC 5+
  • Grails calculated field in SQL
  • Jackson Parser: ignore deserializing for type mismatch
  • Error when parsing timestamp with pandas read_csv
  • Is possible to count alias result on mysql
  • DirectX11 ClearRenderTargetViewback with transparent buffer?
  • Why is the timeout on a windows udp receive socket always 500ms longer than set by SO_RCVTIMEO?
  • Web-crawler for facebook in python
  • How to format a variable of double type
  • Unit Testing MVC Web Application in Visual Studio and Problem with QTAgent